DELETE t
FROM
ads_wt_new_import t
WHERE
t.import_time >= '2014-12-04'
AND t.import_time < date_add('2014-12-04', INTERVAL 1 DAY)
AND t.ads_from != 'reg_togame'
AND EXISTS (
SELECT
1
FROM
ads_wt_new_import t2
WHERE t2.server_id = t.server_id
AND t2.user_id = t.user_id
AND t2.ads_from = 'reg_togame'
)报错如下:
[Err] 1093 - You can't specify target table 'pps_ads_wt_new_import' for update in FROM clause如何修改,求大神指导。
解决方案 »
- SELECT * FROM User ORDER BY UserName Limit 80000, 20超慢,怎么优化?
- MYSQL编译时出现的问题
- MYSQL4.1数据库里的数据表内容出现乱码,默认是latin1,想要utf8编码(1064 错误)在线等!
- 用C#查询text类型的内容出错了,不知道怎么解决。
- mysql 查询出一个字段对应另外一字段的2值(在线等)
- 如何向Mysql数据库中插入30万条记录的语句
- mysql.h的问题
- You have an error in your SQL syntax 这个错误提示是什么意思啊。
- java连接mysql,oracle,sqlserver的类(源代码):
- 求助这个sql怎么优化一下
- 存储过程执行出错
- 关于mysql创建表分区,让id自增长、加上主键的话就报错,取消就能创建成功的问题!求大神帮助下!!!
DELETE t
FROM
ads_wt_new_import t,
(
SELECT server_id,user_id
FROM ads_wt_new_import
WHERE ads_from = 'reg_togame'
) t2
WHERE
t.import_time >= '2014-12-04'
AND t.import_time < date_add('2014-12-04', INTERVAL 1 DAY)
AND t.ads_from != 'reg_togame'
and t2.server_id = t.server_id
AND t2.user_id = t.user_id