Menu

Alias names in quotes

Ramesh
2006-09-18
2012-12-07
  • Ramesh

    Ramesh - 2006-09-18

    Does jsqlparser support alias name of a select column in quotes? I could not succeed with the following query:

      SELECT mycolumn AS 'My Column Name' FROM mytable

     
    • Leonardo Francalanci

      I'll see if I can do something. Stay tuned.

       
  • Nobody/Anonymous

    What was the outcome of this?  I am having the same problem.

     
  • Leonardo Francalanci

    I don't think that

    SELECT mycolumn AS 'My Column Name' FROM mytable

    is standard; the standard would be:

    SELECT mycolumn AS "My Column Name" FROM mytable

    (which works in jsqlparser)
    On which database the ' char is allowed as alias identifier???

     

Log in to post a comment.