mysql_tquery - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql_tquery (/showthread.php?tid=616571)

---

mysql_tquery - MerryDeer - 07.09.2016

Hi,

mysql_tquery will wait until last query will be excecuted? because i'am sending 3 queries like that


mysql_tquery("DELETE ...");
mysql_tquery("UPDATE ...");
mysql_tquery("SELECT ...");

I'am deleting, updating, and selecting from one table at one time. It's always first delete, update, and then select that new result?

---

Re: mysql_tquery - Luis- - 07.09.2016

I don't think it works like that. It depends which one actually gets through first, if you're sending them all in one function / command.

---

Re: mysql_tquery - MerryDeer - 07.09.2016

Strange somebody says that difference between mysql_tquery and mysql_pquery is that mysql_tquery is waiting until previuos are complete, all queries are in row and have to complete that last querie will by complete. but i'am asking to somebody too confirm that

---

Re: mysql_tquery - maddinat0r - 07.09.2016

If you send queries through mysql_tquery, they're guaranteed to be executed in the order they were sent. So yes, in your example first the DELETE, then the UPDATE and after that the SELECT query will be sent.

mysql_pquery on the other side does not make this promise. Queries can be executed out of order.

---