- Notifications
You must be signed in to change notification settings - Fork689
UPPER or lower case
Mathias Rangel Wulff edited this pageJul 11, 2015 ·1 revision
By default, AlaSQL is case-insensitive to all standard keywords (like SELECT) and standard functions (like ABS()). All database names, table names, column names, and user-defined functions are case sensitive.
JavaScript is case-sensitive language, so use the same CaSe for AlaSQL and JavaScript data.
Now you can use databases, tables, and columns with spaces inside square brackets:
CREATE DATABASE [My Database];-- BTW You can use comments in the SQL statements USE [My Database];/* or comments like this*/ CREATE TABLE [A.table] ([the-column]INT);INSERT INTO [A.table]VALUES (1),(2);SELECT [the-column]AS [AS]FROM [My Database];
Try this sample in [AlaSQL console](http://alasql.org/console?CREATE DATABASE [My Database];USE [My Database];CREATE TABLE [A.table] ([the-column] INT);INSERT INTO [A.table] VALUES (1),(2);SELECT [the-column] AS [AS] FROM [My Database])
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo