RE: [sqlite] Re: Help with IF NOT EXiSTS

Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, January 30, 2006 10:45 AM To: SQLite Subject: [sqlite] Re: Help with IF NOT EXiSTS nbiggs wrote: > I get the following error if I try to use the IF NOT EXISTS function. > If I take out the "IF NOT EXISTS", the statement creates the i

Re: [sqlite] Re: Help with IF NOT EXiSTS

Quoting Igor Tandetnik ([EMAIL PROTECTED]): > nbiggs wrote: > >CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2); > >SQL error: near "NOT": syntax error > > I've never seen such syntax. SQLite does not support it. What is it > supposed to mean anyway? I think it's a MySQL-ism

[sqlite] Re: Help with IF NOT EXiSTS

nbiggs wrote: I get the following error if I try to use the IF NOT EXISTS function. If I take out the "IF NOT EXISTS", the statement creates the index. The same happens when I try using IF NOT EXISTS in a CREATE table statement. CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field