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

8 votes326 views1 answer
Mysql restore database
SQL
8 votes358 views1 answer
Ltrim sql
SQL
0 vote324 views1 answer
Mysql group by derived column
SQL
0 vote349 views1 answer
Case insensitive sql
SQL
0 vote350 views1 answer
Cast float mysql
SQL
1 vote369 views1 answer
Mysql connect bash
SQL
0 vote332 views1 answer
Oracle c# multiple update sql
SQL
0 vote327 views1 answer
Mysql default uuid
SQL
11 votes366 views4 answers
Update row in mysql
SQL
1 vote331 views1 answer
Mysql batch insert
SQL