On Tue, 27 Jul 2010 14:40:11 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>I'm having a problem with this PHP5 script running under Nginx +
>PHP5-FPM and PDO-SQLite3
Found it: For newbies like me... "table" is a reserved name so cannot
be used as a name to table:
============
#BAD $dbh->exec("CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY
KEY AUTOINCREMENT, name VARCHAR(255))");
#BAD $dbh->exec("INSERT INTO table (name) VALUES ('dummy')");
$dbh->exec("CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY
AUTOINCREMENT, name VARCHAR(255))");
$dbh->exec("INSERT INTO mytable (name) VALUES ('dummy')");
============
HTH,
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
