How can I delete multiple MySQL tables? This is a problem that many people have mentioned. The following describes how to delete multiple tables in MySQL for your reference.
1. Delete all matching records with id values in Table T2.
DELETE t1 FROM t1, t2 WHERE t1.id = t2.id or delete from t1 USING t1, t2 WHERE t1.id = t2.id
2. Find and delete no matching records in data table T2.
DELETE t1 FROM t1 left join T2 ON t1.id = t2.id WHERE t2.id is null or
Delete from t1, USING t1 left join T2 ON t1.id = t2.id WHERE t2.id IS NULL
3. Find the data with the same record from the two tables and delete the data from both tables.
DELETE t1, t2 from t1 left join t2 ON t1.id = t2.id WHERE t1.id = 25
Note that delete t1, t1 in t2 from, and t2 cannot be aliases.
For example, delete t1, t2 from table_name as t1 left join table2_name as t2 on t1.id = t2.id where table_name.id = 25 execution in data is incorrect MYSQL version not less than 5.0 is acceptable in 5.0)
The preceding statement is rewritten
Delete table_name, table2_name from table_name as t1 left join table2_name as t2 on t1.id = t2.id where table_name.id = 25 execution in the data is incorrect. MYSQL versions earlier than 5.0 are acceptable in MYSQL 5.0)
Appendix: MySQL 4.0.2 or above is the environment where the MYSQL multi-Table deletion statement is run.
Advantages and disadvantages of MySQL independent tablespace
Case sensitivity of mysql Databases
Restoration of MySQL MyISAM Table Structure
MySQL multi-Table Union query syntax example
Alternative usage of MySQL table alias