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

0 vote109 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote112 views1 answer
Top 3 salary in sql
SQL
3 votes109 views1 answer
Select count from table mysql
SQL
0 vote122 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote105 views1 answer
Scaffold mysql database
SQL
8 votes137 views1 answer
Mysql dump restore
SQL
0 vote193 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote173 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote121 views2 answers
What is the default password for sql server sa
SQL
0 vote104 views1 answer
Find largest table in mysql database
SQL