mysql - 插入时出现 SQL 错误

Question

下面的SQL语句有什么问题？

INSERT INTO thread (deleted) 
VALUES ('2009-01-02 17:41:02') 
WHERE thread.id = 28

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 thread.id = 28' at line 3

编辑:我真是个白痴...更新!!!

谢谢。

Answer 1

http://dev.mysql.com/doc/refman/5.0/en/update.html

UPDATE thread 
   SET deleted = TIMESTAMP '2009-01-02 17:41:02'
 WHERE id = 28;