On Sep 9, 2010, at 3:56 PM, thomas veymont wrote: > hello, > > I'm trying to use the "CREATE TABLE AS" syntax to create a table and > insert > in the same time a default row. > > e.g : > > sqlite> CREATE TABLE test (x NUMERIC) AS (SELECT 25 AS x); > Error: near "AS": syntax error > > oops. > > this syntax is documented in http://www.sqlite.org/lang_createtable.html > sqlite version is 3.6.20
The diagram is meant to be interpreted such that a CREATE TABLE may have either a list of columns in parenthesis or an "AS SELECT" clause. Not both. http://www.sqlite.org/syntaxdiagrams.html#create-table-stmt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
