Re: [sqlite] Problem if IF NOT EXISTS

2009-09-23 Thread Andrew
*slaps self* Thanks for all the help- can't beleive I was duped by something so obvious... heh. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem if IF NOT EXISTS

2009-09-23 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andrew wrote: > I didn't see a way to search the mail archive, Go to http://sqlite.org/support.html and look in the middle of the page where it describes the mailing lists. All 3 links to archives take you to pages that then have an option to search

Re: [sqlite] Problem if IF NOT EXISTS

2009-09-23 Thread Igor Tandetnik
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

Re: [sqlite] Problem if IF NOT EXISTS

2009-09-23 Thread D. Richard Hipp
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

[sqlite] Problem if IF NOT EXISTS

2009-09-23 Thread Andrew
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 d