J.O. Aho
06-17-2008, 03:31
CS student wrote:
> What i don't understand is when should i use `` and when '' when using
> aliases?
> E.g.: why does the expression: as '[my numbers].number'
> Works with '', while the expression: GROUP BY '[my numbers].number';
> Must have `` to work correct?
> In the MYSQL documentation, it's not clear what are the exact rules
> for defining and using aliases, for both columns selections and
> tables.
As I have understood, '' is used for "strings", as when you define a new
alias, it's an string and you use `` for enclose column/alias/table names that
you use them.
--
//Aho
> What i don't understand is when should i use `` and when '' when using
> aliases?
> E.g.: why does the expression: as '[my numbers].number'
> Works with '', while the expression: GROUP BY '[my numbers].number';
> Must have `` to work correct?
> In the MYSQL documentation, it's not clear what are the exact rules
> for defining and using aliases, for both columns selections and
> tables.
As I have understood, '' is used for "strings", as when you define a new
alias, it's an string and you use `` for enclose column/alias/table names that
you use them.
--
//Aho