--单表删除
--========================================
DELETE FROM TB1
WHERE TB1.ID>10;
--========================================
DELETE FROM TB2
WHERE TB2.ID>10
ORDER BY TB2.ID
LIMIT 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,T2
USING TB1 AS T1
INNER JOIN TB2 T2
ON T2.ID=T1.ID
INNER JOIN TB3 T3
ON T2.ID=T3.ID
WHERE T3.ID>10
--========================================
DELETE FROM T1,T2
USING TB1 AS T1,TB2 AS T2,TB3 AS T3
WHERE T2.ID=T1.ID
AND T2.ID=T3.ID
AND T3.ID>10
