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

7 votes266 views1 answer
Sql server convert string to date
SQL
16 votes284 views2 answers
Mysql date between two dates
SQL
0 vote268 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote273 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote263 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
4 votes256 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote272 views1 answer
Select insert new table sql server
SQL
0 vote260 views1 answer
Compare if is null sql
SQL
1 vote274 views1 answer
Sql first day quarter
SQL
15 votes260 views2 answers
Install mysql 8 ubuntu 18.04
SQL