摘要: 1、多表联合删除:DELETE t1,t2 FROM table1 as t1 left join table2 as t2 on t1.ID = t2.TICKETS_ID WHERE t2.TICKETS_ID = 12;或者DELETE table1,table2 FROMtable1 left jointable2 on table1.ID = table2.TICKETS_ID WHERE table2.TICKETS_ID = 12;2.在多个表联合删除时,不能使用order by 或limit,而单个表的删除时就没有这个限制。3.当前,我们还不能在删除表的时候,在子查询中sele 阅读全文
posted @ 2012-07-20 16:27 虚一而静 阅读(6999) 评论(0) 推荐(1) 编辑