联表删除

时间:2014-08-21 17:06:14   收藏:0   阅读:279
delete from table1 where table1.column1 IN (SELECT column2 FROM table2 WHERE column3 = ‘XXXXXXXXX‘)
//table1的column1的值等于table2的column2的值

 

联表删除,布布扣,bubuko.com

原文:http://www.cnblogs.com/kangjing/p/3927447.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!