Cacher is the code snippet organizer for pro developers

for 000000 date :

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';
SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';


problem foreign key


Try DISABLE KEYS or

SET FOREIGN_KEY_CHECKS=0;
make sure to

SET FOREIGN_KEY_CHECKS=1;
after.