mysql disable referential integrity

Question

I want to drop all the schemas in a mysql db, and I don't want to be bothered with referential integrity errors

in h2 it's done like this

SET REFERENTIAL_INTEGRITY FALSE;
drop table if exists company;
drop table if exists computer;
SET REFERENTIAL_INTEGRITY TRUE;

How can it be achieved in mysql?

thanks a lot, both solutions worked, I just selected the first one as correct, and upvoted both... — opensas, Mar 31 '12 at 20:28

score 18 · Accepted Answer · answered Mar 31 '12 at 17:02

18

This should work:

SET @@foreign_key_checks = 0;

DROP TABLE IF EXISTS company;
DROP TABLE IF EXISTS computer;

SET @@foreign_key_checks = 1;

answered Mar 31 '12 at 17:02

BluesRockAddict

score 14 · Answer 2 · answered Mar 31 '12 at 17:03

14

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS company;

DROP TABLE IF EXISTS computer;

SET FOREIGN_KEY_CHECKS = 1;

answered Mar 31 '12 at 17:03

ruakh

2 Answers2