+ 1
Is 'AS' creating a temporary alias or a true new column?
For exemple with the folowing code : SELECT CONCAT(FirstName,', ', City) AS new_column FROM customers; Will the column "new_column" be created or is it a kind of alias which disappear at the end of the request?
3 Answers
+ 11
Correction: it is ALTER TABLE and so on.
+ 10
AS is temporary. For a new column use
ALTER tablename ADD columnname type.
+ 1
Oh yeah, thanks!