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

5 votes304 views1 answer
Oracle nls instance
SQL
0 vote281 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote298 views1 answer
Alter fedora mysql 8.0 user
SQL
7 votes323 views4 answers
Index in mysql
SQL
1 vote283 views1 answer
Crontab every month
SQL
1 vote283 views1 answer
How to truncate a table in databse
SQL
0 vote297 views1 answer
Mysql count unique in group statement
SQL
0 vote280 views1 answer
Replace sqlalchemy
SQL
-1 vote313 views1 answer
Default username and password for oracle 11g
SQL
0 vote289 views1 answer
Using GROUP BY in MySQL Join Table
SQL