Two queries in one
#3

I had also tried something similar to insert data for racetop (top5) and then directly delete anything but keep 5 best time rows. The result was the same as yours. Even though in phpMyAdmin was executed without any problems so I just send 2 queries instead.

I'm not sure as I never tried, if something like this would work: https://dev.mysql.com/doc/refman/5.0/en/begin-end.html

@Stev: I think UNION is used only for SELECT queries, correct me if I'm wrong.
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: 1 Guest(s)