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 any idea ? thanks for any help, Tom _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users