On 8 March 2011 17:20, Nicolas Sarrasin <[email protected]> wrote: > > Hi all, > I'm new to SQLite and I'm actually trying to convert a .sql script to a .db > file. > I encounter a problem with this code : > CREATE TABLE IF NOT EXISTS mytable( NAME char(100) NOT NULL DEFAULT '', p1 > smallint(5) unsigned DEFAULT NULL, p2 smallint(5) unsigned DEFAULT NULL, p3 > smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (NAME)); > INSERT INTO mytable(NAME, p1, p2, p3) VALUES('Test', 30, 0, 300); > I get the following error : > Error: near line 7: near "unsigned":
"unsigned" is not permitted. See http://www.sqlite.org/lang_createtable.html http://www.sqlite.org/datatype3.html may help also > syntax errorError: near line 15: no such table: mytable > Can someone help me to solve this problem ? > Thanks by advance. > Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
