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?

Despinadespise

thanks a lot, both solutions worked, I just selected the first one as correct, and upvoted both... – Despinadespise

Answer 1

This should work:

SET @@foreign_key_checks = 0;

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

SET @@foreign_key_checks = 1;

Jacquenette

Answer 2

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS company;

DROP TABLE IF EXISTS computer;

SET FOREIGN_KEY_CHECKS = 1;

Heliotherapy