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

1 vote161 views1 answer
What is int in mysql
SQL
20 votes177 views6 answers
Change password in mysql
SQL
12 votes167 views2 answers
Insert multiple rows from another table sql
SQL
2 votes122 views1 answer
Sql group by different columns
SQL
-2 votes164 views3 answers
Oracle tablespace usage
SQL
1 vote158 views2 answers
Mysql spring boot application.properties
SQL
-1 vote176 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote170 views1 answer
Pl/ sql change currency
SQL
1 vote203 views1 answer
Oracle drop chain step
SQL
0 vote219 views1 answer
Compare two tables to find unmatched records
SQL