- Notifications
You must be signed in to change notification settings - Fork689
Quirky
Mathias Rangel Wulff edited this pageMay 29, 2016 ·4 revisions
You can use
[column]or
`column`for columns with spaces, special symbols, etc. This also applys tocolumn named with [reserved keywords](AlaSQL Keywords) independent of the letter case. So names likedate,begin,content,last,max,min,count,natural,path,right,show,temp,timeout,target,top,value, andwork needs to be wrapped.
alasql parses queries as JavaScript strings before parsing them as SQL. Because of this, you need to double escape special characters such as double quotes using two backslashes instead of one. For example:
alasql('SELECT "You should \\"double escape\\" double quotes"')© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo