Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
Mathias Rangel Wulff edited this pageMay 29, 2016 ·4 revisions

Quirky things about AlaSQL

Column names

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.

Escaping characters

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

Clone this wiki locally


[8]ページ先頭

©2009-2025 Movatter.jp