[sqlite] sqlite3 : error while converting .sql to .db

2011-03-08 Thread Nicolas Sarrasin
Ok thanks for your answer and the links !(And sorry for double post.) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite3 : error while converting .sql to .db

2011-03-08 Thread Simon Davies
On 8 March 2011 17:20, Nicolas Sarrasin 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 >

[sqlite] sqlite3 : error while converting .sql to .db

2011-03-08 Thread Nicolas Sarrasin
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

[sqlite] sqlite3 : error while converting .sql to .db

2011-03-08 Thread Nicolas Sarrasin
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 : - Proverbe japonais : " L'eau prend toujours la forme du vase. "