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如何修改,求大神指导。
解决方案 »
- 如何用SQL统计每日金额
- linux下mysql源码安装问题
- sql执行错误问题啊~555[1062 duplicate entry]
- 如何在每天零点,MYSQL自动对各条记录的截至日期进行比较,若超过,则对该记录进行标识
- 问题,在线等。mysql无法访问。
- 对某一表的某一字段或某几字段求和sql语句怎样写呢?
- 关于GROUP BY 统计200W数据优化
- MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout ex
- mysql更新blob字段出现‘数据类型不匹配’
- 急!sql server 2008实时同步mysql要怎么实现?
- 存储过程执行出错
- 关于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