delete 刪除 刪除表中已存在的整行數據。 `delete from table_name where ...order by ...limit...` 如果沒有where條件則會刪除整個表。 `delete from students order by sid limit 1; `刪除以sid升序排序的第一條記錄。 多表刪除：兩種用法： ~~~ delete a1,a2 from t1 as a1 inner join t2 as a2 where a1.id=a2.id; DELETE FROM a1, a2 USING t1 AS a1 INNER JOIN t2 AS a2 WHERE a1.id=a2.id; ~~~ `delete <alias> from <table> <alias> where <alias>.<field>...` 別名必需在 delete之后出一次。