Predmet:Mysql If Exists
ovo nikako da proradi:
IF EXISTS (SELECT * FROM voce WHERE ime='ananas')
{
UPDATE voce SET ukupno=(ukupno+1) WHERE ime='ananas'
}
ELSE
{
INSERT INTO voce VALUES('ananas',0)
};
greska:
#1064 - 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 'IF EXISTS (SELECT * FROM voce WHERE ime='ananas')
{
UPDATE voce SET uku' at line 1
zivot je moja domovina.