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 vote239 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
13 votes245 views4 answers
Mysql remove foreign key constraint
SQL
5 votes216 views3 answers
Truncate function in sql oracle
SQL
10 votes237 views6 answers
Mysql delete duplicates
SQL
0 vote220 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote235 views2 answers
How to search date in sql query
SQL
0 vote228 views1 answer
Postgresql import a database of gzip
SQL
0 vote237 views1 answer
Oracle date winter time
SQL
0 vote236 views1 answer
How to select all fieldsin a soql query
SQL
0 vote228 views1 answer
Psql store procedure-return multiple table values
SQL