[thelist] insert if select fails to find element

Alex Beston alex at deltatraffic.co.uk
Thu Nov 17 04:44:15 CST 2005


 oh ok. will give it a try in a min.

i just tried this one:

INSERT into word_list(word) VALUES ('$word') WHERE NOT EXISTS (SELECT 
word FROM word_list WHERE word = '$word')

but this:

You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near 'WHERE NOT 
EXISTS (SELECT word FROM word_list WHERE word = 'zymurgy')' at line 1

hmm.

/scratches head

A.

>>
>>is there a way of putting all the work on the sql - something like
>>
>>""INSERT into word_list(word) VALUES ('$word')" IF ('$word') NOT EXISTS";
>>
>>    
>>
>
>This is roughly the sql syntax you are looking for. I don't know whether it
>will work in mysql though - a quick look at the manual didn't turn anything
>up, so you might as well just try it and see what happens.
>
>IF NOT EXISTS (SELECT word FROM word_list WHERE word='$word') INSERT INTO
>word_list(word) VALUES ('$word');
>
>
>  
>


-- 
-_-_-_-_-_-_-_-_-_-_-

  deltatraffic.co.uk

  Current Location:
  KL, Malaysia
 
_-_-_-_-_-_-_-_-_-_-_




More information about the thelist mailing list