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 vote186 views1 answer
Query builder doctrien return sql
SQL
0 vote177 views1 answer
Postgres declare variable
SQL
0 vote172 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote158 views1 answer
Sql where time stamp is in between
SQL
11 votes186 views1 answer
Oracle export view ddl
SQL
0 vote172 views1 answer
How to fetch unique records from two tables
SQL
6 votes165 views1 answer
Sql insert values into table
SQL
1 vote159 views2 answers
Postgresql list columns
SQL
44 votes226 views4 answers
Mysql alter table add column first
SQL
0 vote206 views1 answer
Update mysql from paypal shopping cart and ipn
SQL