Inayofanywa na SQL Alias (Mtaalamu)

Kwa kutumia SQL, inaweza kuwasiliana jina la kina na jina la tablio kwa jina la kina (Alias).

SQL Alias

Inayofanywa kwa SQL kwa jina la tablio

SELECT column_name(s)
FROM table_name
AS alias_name

Inayofanywa kwa SQL kwa jina la kina la maelezo

SELECT column_name AS alias_name
FROM table_name

Mfano wa Alias: Kipindea jina la tablio kwa jina la kina

Tunapendelea kuwa tunameene watawili mbali mbali ni "Persons" na "Product_Orders". Tunasema jina la kina "p" na "po" kwa kila watawili hivi.

Sasa, tunanua kuonyesha kila inaingia "John Adams".

Tunaweza kutumia maelezo ya SELECT inayotunuliwa hapa:

SELECT po.OrderID, p.LastName, p.FirstName
FROM Persons AS p, Product_Orders AS po
WHERE p.LastName='Adams' AND p.FirstName='John'

Select ya SQL ingepunguza jina la kina:

SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName
FROM Persons, Product_Orders
WHERE Persons.LastName='Adams' AND Persons.FirstName='John'

Kutoka kufikia kufikia maelezo ya SELECT mbili juu, inavyotazama kwamba jina la kina linasaidia kusoma na kusoma kwa maelezo.

Mfano wa Alias: Tumia jina la kolumu kama jina kina

Jadili ya Persons:

Id LastName FirstName Adress Mji
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing

SQL:

SELECT LastName AS M familia, FirstName AS Jina
FROM Persons

Matokeo:

M familia Jina
Adams John
Bush George
Carter Thomas