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 vote172 views1 answer
Postgres select except
SQL
0 vote186 views1 answer
Criteria builder select subset of column
SQL
1 vote221 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote168 views1 answer
In mysql workbench contnent not feching
SQL
0 vote183 views1 answer
See Foreign Key
SQL
0 vote342 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote206 views1 answer
Sql server create constraint
SQL
0 vote196 views1 answer
Sql new line output
SQL
0 vote228 views1 answer
SQL get max per id
SQL
3 votes203 views1 answer
Mysql replace string in table
SQL