我如何更新表(MYSQL) [英] How do I update the table(MYSQL)

问题描述

系统抛出错误您不能在 FROM 子句中指定更新的目标表‘筛选’"我如何完成这样的更新?

the system throw a error "You can't specify target table 'screening' for update in FROM clause" How do I completed the update like this?

 UPDATE screening
  SET maileddate = date('Y-m-d', strtotime($mailed_date[$screeningId]))
  WHERE user_id IN (SELECT id FROM users
  INNER JOIN screening ON
  (users.id = screening.users_id
  AND screening.id = {$screeningId}))
  AND date BETWEEN 05-15/2011 AND 11-15-2011
  LIMIT 2

推荐答案

尝试将 LIMIT 子句放在 SELECT 子查询中.

Try putting the LIMIT clause in your SELECT subquery.

这篇关于我如何更新表(MYSQL)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！