Advertisement
Guest User

Untitled

a guest
Jul 24th, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. UPDATE `mdl_modules` SET `visible`=0
  2. WHERE `name` IN ("survey","feedback","audio","testing")
  3.  
  4. UPDATE `db_name1`.`mdl_modules`, `db_name2`.`mdl_modules`,`db_name3`.`mdl_modules`
  5. SET `visible`=0 WHERE `name`
  6. IN ("survey","feedback","audio","testing")
  7.  
  8. START TRANSACTION;
  9. UPDATE `db_name1`.`mdl_modules` SET `visible`=0
  10. WHERE `name` IN ("survey","feedback","audio","testing");
  11. UPDATE `db_name2`.`mdl_modules` SET `visible`=0
  12. WHERE `name` IN ("survey","feedback","audio","testing");
  13. UPDATE `db_name3`.`mdl_modules` SET `visible`=0
  14. WHERE `name` IN ("survey","feedback","audio","testing");
  15. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement