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

11 votes135 views3 answers
Sqlite3 create table from another table
SQL
1 vote141 views1 answer
Postgresql transaction discard all
SQL
0 vote136 views1 answer
Mysql where in keep order
SQL
1 vote138 views1 answer
Simple project for database
SQL
7 votes152 views4 answers
Database dump mysql command
SQL
0 vote139 views1 answer
Create table database in psql
SQL
1 vote125 views1 answer
Oracle lock user
SQL
0 vote155 views1 answer
Postgres get database encoding
SQL
0 vote132 views4 answers
Sql year
SQL
1 vote150 views1 answer
Trim leading zeros in sql
SQL