- Notifications
You must be signed in to change notification settings - Fork689
Insert Values
Mathias Rangel Wulff edited this pageJun 12, 2015 ·3 revisions
Syntax:
INSERT INTO tableidVALUES (vaule,...), ...INSERT INTO tableidVALUES {key:value, ...}, ...
For example:
alasql('CREATE TABLE Cities (City STRING, Population NUMBER)');alasql('INSERT INTO Cities VALUES ("Moscow", 11500000), ("London",6000000)');alasql('INSERT INTO Cities VALUES ?',[{City:'Berlin',Population:4300000}]);alasql('INSERT INTO Cities VALUES (?,?)',["Beijing",5000000]);alasql('INSERT INTO Cities VALUES {City:"Paris",Population:5000000}');
See also:INSERT andINSERT SELECT
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo