Mysql语法错误: 'WHERE NOT LIKE'

Question

我试图通过每 24 小时仅插入唯一值来跟踪页面 View 。但是当我运行此查询时，出现语法错误。

insert ignore into profilepageviews values( '77.777.777.777' , CURRENT_TIMESTAMP, '5') where hitdate NOT LIKE '%2012-06-26%'

错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where hitdate NOT LIKE '%2012-06-26%'' at line 1

Answer 1

您不能将 WHERE 子句与 INSERT 一起使用，您可能需要 UPDATE