mysql - 更新日期字段 - mysql 不工作

Question

谁能告诉我查询出了什么问题吗？

UPDATE user_package
SET project_applications = '5'
AND refresh_date = '2016-04-26'
WHERE   package_id = '12'
AND refresh_date = '2016-03-27';

Answer 1

将 AND 替换为逗号 (,)

试试这个:

UPDATE user_package
SET project_applications = '5',
 refresh_date = '2016-04-26'
WHERE   package_id = '12'
AND refresh_date = '2016-03-27';