Two queries in one
#1

It's possible to send two queries in one SQL statement, right?

pawn Код:
UPDATE `players` SET `Name` = '%e' WHERE `PlayerID` = '%i'; DELETE FROM `players` WHERE `PlayerID` = '%i'
Using mysql_format().

I'm getting this error:
Quote:

[18:44:45] [ERROR] CMySQLQuery::Execute[QR_OnChangeNameSuccess] - (error #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 'DELETE FROM `players` WHERE `PlayerID` = '47'' at line 1

Reply


Messages In This Thread
Two queries in one - by MP2 - 23.05.2015, 17:42
Re: Two queries in one - by Stev - 23.05.2015, 17:48
Re: Two queries in one - by Konstantinos - 23.05.2015, 17:49
Re: Two queries in one - by MP2 - 23.05.2015, 17:51
Re: Two queries in one - by Sithis - 23.05.2015, 17:58
Re: Two queries in one - by MP2 - 23.05.2015, 17:59
Re: Two queries in one - by Konstantinos - 23.05.2015, 18:53
Re: Two queries in one - by Sithis - 24.05.2015, 10:24
Re: Two queries in one - by Yashas - 24.05.2015, 10:33
Re: Two queries in one - by Konstantinos - 24.05.2015, 10:42

Forum Jump:


Users browsing this thread: 2 Guest(s)