Question

How to use Alias for columns in SQL

Answer 1

SELECT FirstName AS fn
FROM Workers

 

70+ SQL courses for beginners and professionals

Answer 2

-- Work with MySQL

SELECT DISTINCT category AS 'c t' -- Two words quotes around column alias
FROM info_table

-- Use with $row['c t']

 

70+ SQL courses for beginners and professionals

Answer 3

-- Work with MySQL

SELECT CONCAT(category,',',info) AS ci
FROM info_table

-- Use with $row['ci']

 

70+ SQL courses for beginners and professionals