Home > database >  MySQL setup FOREIGN_KEY_CHECKS cannot take effect
MySQL setup FOREIGN_KEY_CHECKS cannot take effect

Time:01-08

The drop table with foreign key test_a times wrong,
According to the method of online operation is still an error, as follows:
The set FOREIGN_KEY_CHECKS=0; Select @ @ FOREIGN_KEY_CHECKS; Drop table test_a;

Question: why is the select @ @ FOREIGN_KEY_CHECKS; The value is 1, still can't drop test_a;
  • Related