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 vote131 views1 answer
Postgresql replace html tags from string
SQL
0 vote129 views1 answer
Systems sql
SQL
0 vote114 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote134 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote119 views1 answer
Import mysql'
SQL
0 vote108 views1 answer
Mysql multiple count
SQL
1 vote109 views1 answer
Oracle select first result
SQL
0 vote117 views1 answer
Sql server count all tables rows
SQL
0 vote130 views2 answers
Sql max count
SQL
24 votes112 views4 answers
How to add column sql
SQL