Is it possible to simultaneously execute two update requests in phpmyadmin?

Question

Is it possible to execute two update requests in phpmyadmin together?

How wise

UPDATE jos_menu SET home = 0 WHERE 1; UPDATE jos_menu SET home = 1 WHERE id = 9; 

Now can we copy both of these queries together and run it in the phpmyadmin sql query bar? will it be done?

Answer 1

Yes, both requests will be completed. The only extra thing you can add is a transaction . This will ensure that both requests are successful:

 START TRANSACTION; UPDATE jos_menu SET home = 0 WHERE 1; UPDATE jos_menu SET home = 1 WHERE id = 9; COMMIT; 

Answer 2

 update jos_menu set home=case id when 9 then 1 else 0 end 

this will update all rows, setting 1 for all that have id = 9, and 0 for the rest

Answer 3

If you are not sure that any SQL will violate your live site and you do not have a development server, make a copy of the DB table and test it on this.

 CREATE TABLE jos_menu_test LIKE jos_menu; INSERT jos_menu_test SELECT * FROM jos_menu;