
        
        
            
                
                
                    -- Alias for column
SELECT column_name AS alias
FROM table_name;

-- Alias for table
SELECT alias.column_name
FROM table_name AS alias;

-- We can also provide a table alias leaving out AS
SELECT alias.column_name
FROM table_name alias;

Examples

Consider the following table about some students:

student_id	fname	lname	day_enrolled	age	username
1	Sky	Towner	2015-12-03	17	stowner1
2	Ben	Davis	2016-04-20	19	bdavis2
3	Travis	Apple	2018-08-14	18	tapple3
4	Arthur	David	2016-04-01	16	adavid4
5	Benjamin	Town	2014-01-01	17	btown5

The above sample table can be created using the code here.

Column alias

To provide aliases for columns fname, lname and day_enrolled:


        
        
            
                
                
                    SELECT fname AS "First Name", lname AS "Last Name", day_enrolled AS "Day Enrolled"
FROM students;
                
            
            +------------+-----------+--------------+
| First Name | Last Name | Day Enrolled |
+------------+-----------+--------------+
| Sky        | Towner    | 2015-12-03   |
| Ben        | Davis     | 2016-04-20   |
| Travis     | Apple     | 2018-08-14   |
| Arthur     | David     | 2016-04-01   |
| Benjamin   | Town      | 2014-01-01   |
+------------+-----------+--------------+

This works also with concatenated columns:


        
        
            
                
                
                    SELECT CONCAT(fname,' ', lname) AS "Full Name", day_enrolled AS "Day Enrolled"
FROM students;
                
            
            +---------------+--------------+
| Full Name     | Day Enrolled |
+---------------+--------------+
| Sky Towner    | 2015-12-03   |
| Ben Davis     | 2016-04-20   |
| Travis Apple  | 2018-08-14   |
| Arthur David  | 2016-04-01   |
| Benjamin Town | 2014-01-01   |
+---------------+--------------+

Table alias

To provide an alias s for table students:


        
        
            
                
                
                    SELECT s.fname, s.lname, s.day_enrolled
FROM students AS s;
                
            
            +----------+--------+--------------+
| fname    | lname  | day_enrolled |
+----------+--------+--------------+
| Sky      | Towner | 2015-12-03   |
| Ben      | Davis  | 2016-04-20   |
| Travis   | Apple  | 2018-08-14   |
| Arthur   | David  | 2016-04-01   |
| Benjamin | Town   | 2014-01-01   |
+----------+--------+--------------+

The AS keyword may actually be left out when providing a table alias:


        
        
            
                
                
                    SELECT s.fname, s.lname, s.day_enrolled
FROM students s;
                
            
            +----------+--------+--------------+
| fname    | lname  | day_enrolled |
+----------+--------+--------------+
| Sky      | Towner | 2015-12-03   |
| Ben      | Davis  | 2016-04-20   |
| Travis   | Apple  | 2018-08-14   |
| Arthur   | David  | 2016-04-01   |
| Benjamin | Town   | 2014-01-01   |
+----------+--------+--------------+