select 可以查询到相应行,可是却不能delete 可是select到表内容, 把SELECT 换成DELETE却不行了请大牛们看看代码SELECT * FROM table1 t1JOIN table2 t2 ON t1.id = t2.idWHERE t2.name ='blahblah' 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DELETE * FROM t2 WHERE t2.name = 'blahblah' delete t2.* from t2,t1 where t1.id = t2.idand t2.name ='blahblah' delete t2.* from t2 inner join t1 on t1.id = t2.idwhere t2.name ='blahblah' DELETE FROM table1 t1JOIN table2 t2 ON t1.id = t2.idWHERE t2.name ='blahblah' delete t1.* from aa t1 inner join aa1 t2 on t1.id = t2.idwhere t2.id ='blahblah' 正解, 谢谢,是不是我原来的代码没有delete t2.* 呢? 还是inner的关系? 呵呵,还没有看到你的DELETE代码 我就是把select *换成deleteDELETE FROM table1 t1JOIN table2 t2 ON t1.id = t2.idWHERE t2.name ='blahblah' 求mysql 存储过程里,实现like mysql动态sql问题 如何获得当前自增ID mysql 判断替换字符串 MYSQL如何使用关键字做列 mysql.ini里面怎么设置Slow Query Log 如何修改视图的显示为utf8????(系统好象默认为latin 从上面可以看出来) 请问MySQL有OLEDB驱动连数据库吗? 如何用命令行方式实现mysql数据库的用户权限设置以及远程连接设置? 安装mysql后,过一会目录空了!!求解 谁做过这个.... postgreSQL免安装版本速度问题。
and t2.name ='blahblah'
where t2.name ='blahblah'
DELETE FROM table1 t1JOIN table2 t2 ON t1.id = t2.idWHERE t2.name ='blahblah'
where t2.id ='blahblah'
正解, 谢谢,是不是我原来的代码没有delete t2.* 呢? 还是inner的关系?
我就是把select *换成deleteDELETE FROM table1 t1JOIN table2 t2 ON t1.id = t2.idWHERE t2.name ='blahblah'