Skip to content

Insert Default Values

Mathias Rangel Wulff edited this page Jun 12, 2015 · 3 revisions

Keyword DEFAULT VALUES

Syntax:

    INSERT INTO tableid DEFAULT VALUES;

For example:

   alasql('CREATE TABLE Orders (OrderNo INT DEFAULT 1, Desc STRING DEFAULT "Something")');
   alasql('INSERT INTO Orders DEFAULT VALUES');

See also: DEFAULT, INSERT

Clone this wiki locally