Merging mysql queries or running them in one attempt

labhijitp · #1 (**permalink**) 04-25-11, 07:53

I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query.

Code:

UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) WHERE runquery.table2.`itemid` = 3 AND runquery.table1.`Userids` = runquery.table2.`userid`;
UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column2` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) WHERE runquery.table2.`itemid` = 5 AND runquery.table1.`Userids` = runquery.table2.`userid`;

r937 · #2 (**permalink**) 04-25-11, 08:04

can't be done in one, was already tried here

labhijitp · #3 (**permalink**) 04-25-11, 08:07

how about using UNION? Or may be modify it by using INSERT INTO ?

Internet Services

Web Development

Digital Marketing

Consumer Tech