• switch off foreign keys for operation with data:
    • SET foreign_key_checks = 0;
  • switch off save update mode for more complicated updates:
    • SET SQL_SAFE_UPDATES = 0;