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 vote138 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote220 views1 answer
Select all same column value in sql
SQL
7 votes187 views3 answers
Postgre describe table
SQL
16 votes213 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote196 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
3 votes228 views1 answer
Set default today mysql
SQL
4 votes261 views2 answers
DB::transaction
SQL
9 votes210 views6 answers
Check constraint in sql
SQL
2 votes193 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
1 vote200 views1 answer
Update substring in mysql
SQL