Mysql drop table cascade

SET FOREIGN_KEY_CHECKS = 0;
drop table if exists <your_1st_table>;
drop table if exists <your_2nd_table>;
SET FOREIGN_KEY_CHECKS = 1;

Source: stackoverflow.com

Alter table add on delete cascade mysql

ALTER TABLE TABLEName
drop CONSTRAINT FK_CONSTRAINTNAME;

ALTER TABLE TABLENAME
ADD CONSTRAINT FK_CONSTRAINTNAME
    FOREIGN KEY (FId)
    REFERENCES OTHERTABLE
        (Id)
    ON DELETE CASCADE ON UPDATE NO ACTION;

Source: stackoverflow.com

Similar codes

-2 votes200 views1 answer
Remove root password mysql
SQL
0 vote241 views1 answer
Create a plsql object
SQL
0 vote218 views1 answer
Mysql value ends with
SQL
0 vote235 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote237 views1 answer
Wordpress change url phpmyadmin
SQL
-1 vote279 views1 answer
Minus vs except in sql
SQL
0 vote169 views1 answer
Import sql file in mysql linux
SQL
0 vote194 views1 answer
How to insert a uniqueidentifier in sql
SQL
5 votes190 views1 answer
JBDC
SQL
6 votes210 views2 answers
Foreign key sqlite3 python
SQL