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": syntax errorError: near line 15: no such
table: mytable
Can someone help me to solve this problem ?
Thanks by advance.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
