Can IF be used to start a MySQL query?
Posted
by
Littledot
on Stack Overflow
See other posts from Stack Overflow
or by Littledot
Published on 2010-12-22T07:49:31Z
Indexed on
2010/12/22
7:54 UTC
Read the original article
Hit count: 150
mysql
|if-statement
Hi there, I have a query that looks like this:
mysql_query("IF EXISTS(SELECT * FROM predict WHERE uid=$i AND bid=$j)
THEN UPDATE predict SET predict_tfidf=$predict_tfidf WHERE uid=$i AND bid=$j
ELSE INSERT INTO predict (uid, bid, predict_tfidf) VALUES('$i','$j','$predict_tfidf')
END IF")or die(mysql_error());
But it dies and mysql tells me to check the syntax near IF EXISTS(....)
Can we not use an IF statement to start a mysql query?
Thank you in advance.
© Stack Overflow or respective owner