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

17 votes338 views6 answers
MySQL ORDER BY
SQL
-1 vote334 views1 answer
Mysql case when multiple conditions
SQL
1 vote347 views1 answer
Oracle datafile max size 32gb
SQL
0 vote352 views1 answer
Excel export from sql using python
SQL
2 votes312 views1 answer
Get first 3 letters name in sql
SQL
0 vote316 views1 answer
Wordpress sql change site url
SQL
-1 vote326 views3 answers
Create temp table in sql
SQL
7 votes349 views2 answers
Where keyword sql
SQL
0 vote377 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote329 views1 answer
Oracle date summer time
SQL