On Sep 23, 2009, at 2:43 PM, Andrew wrote: > I didn't see a way to search the mail archive, so hopefully this > hasn't been > addressed repeatedly in the past... > > $ sqlite data.dat > SQLite version 2.8.17 > Enter ".help" for instructions > sqlite> .schema > sqlite> CREATE TABLE IF NOT EXISTS t ( foo int ); > SQL error: near "NOT": syntax error > sqlite> > > I don't know why this statement isn't working, as it appears in the > documentation. Is there a workaround?
Support for IF NOT EXISTS was added to the SQLite version 3.x.x series in January 2006. Version 2.8.17 is from December 2005. Development on the 2.x.x series ended at that point. There will be no further enhancements to 2.8.17. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
