MySQL ALIAS Tutorial - Skracenje Imena Kolone

Moze se desiti da nam zasmeta dugacko ime tabele, tada u pomoc priskace ALIAS:

SELECT kolona FROM tabela AS nadimak_kolone;

mysql> SELECT prezime FROM kucni AS pre;
+-------------+
| prezime     |
+-------------+
| Peric       |
| Miric       |
| Zorisic     |
| Markovic    |
| Predragovic |
| Petrovic    |
+-------------+
6 rows in set (0.00 sec)

mysql>