[SOLVED] One query, multiple updates

[jaymc]

Is it possible to update numerous tables in the same query, e.g

 

UPDATE `tab1`, `tab2` SET tab1.minutes = '60', tab2.hours = '4'

 

Probably not the syntax, but can it be done rather than using 2 seperate update queries. If so, is it more optimal?

[hemlata]

Hello,

 

Yes, i think it can be done. i tried a simple script on two tables and it run successfully

 

UPDATE table1 AS t1, table2 AS t2 SET t1.field1 = 'test1', t2.field2 = 'test2';

 

Regards,

[jaymc]

Nice

 

Would this improve performance, even if its slight?

 

Assuming Im not closing and opening the mysql connection after every query

 

Or is it simple a neater way of updating multiple tables in the same script

[fenway]

Nice

 

Would this improve performance, even if its slight?

 

Assuming Im not closing and opening the mysql connection after every query

 

Or is it simple a neater way of updating multiple tables in the same script

 

Again with the performance, eh?

 

It's not meant to update multiple tables in the same script... it's meant for updates that require joining multiple tables to produce the result.

[jaymc]

Would I be better just sticking to one query per update then?

[fenway]

Would I be better just sticking to one query per update then?

Yes, unless you need info from another table.