--单表删除--========================================DELETE FROM TB1 WHERE TB1.ID>10;--========================================DELETE FROM TB2 WHERE TB2.ID>10ORDER BY TB2.IDLIMIT 100--========================================DELETE T1 FROM TB1 AS T1 INNER JOIN TB2 AS T2 ON T1.ID=T2.ID WHERE T2.ID>10--========================================DELETE T1 FROM TB1 AS T1,TB2 AS T2 WHERE T1.ID=T2.ID AND T2.ID>10--多表表删除--========================================DELETE FROM T1,T2USING TB1 AS T1 INNER JOIN TB2 T2 ON T2.ID=T1.IDINNER JOIN TB3 T3ON T2.ID=T3.IDWHERE T3.ID>10--========================================DELETE FROM T1,T2USING TB1 AS T1,TB2 AS T2,TB3 AS T3WHERE T2.ID=T1.IDAND T2.ID=T3.IDAND T3.ID>10