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 vote204 views1 answer
Psql get table data types
SQL
0 vote227 views1 answer
Mysql show create db
SQL
2 votes255 views3 answers
Mysql kill
SQL
1 vote233 views1 answer
T-SQL Alter the column data type
SQL
2 votes204 views1 answer
Q operator in sql
SQL
3 votes286 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote205 views1 answer
Mysql where in keep order
SQL
2 votes192 views1 answer
Postgresql left join distinct on
SQL
3 votes240 views1 answer
Sql online test questions and answers
SQL
0 vote234 views1 answer
Sql values not in another table
SQL