update two tables with one query
Posted: Wed Jun 07, 2006 10:12 pm
is it possible to update two tables with one query?
I tried this and it no worky:
I tried this and it no worky:
Code: Select all
UPDATE `privileges` SET `user_dir` = 'files/',`admin` = '1',`mk_dir` = '1',`del_dir` = '1',`upld_dir` = '1',`dnld_dir` = '1',`ren_dir` = '1',`mk_file` = '1',`upld_file` = '1',`del_file` = '1',`dnld_file` = '1',`view_file` = '1',`ren_file` = '1',`edit_file` = '1' WHERE `user_id` = '2'
AND UPDATE `users` SET `user_name` = 'MC2',`pass_word` = 'cfe6ce19a1f65b98a2daa9d8f772bfbcf8bc71d2' WHERE `user_id` = '2'