MySQL error

[filburt1]

I got this:

SQL-query :

INSERT INTO news (what, when) VALUES ('test', NOW())


MySQL said:


You have an error in your SQL syntax near 'when) VALUES ('test', NOW())' at line 1

My database:

mysql> describe news;
+-------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| when | timestamp(14) | YES | | NULL | |
| what | text | | | | |
+-------+---------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

Aroo?

[filburt1]

BTW no, this isn't vB code, just something I'm trying out for myself.

[filburt1]

D'oh! when is a keyword! http://www.mysql.com/doc/en/Reserved_words.html :angry:

[Admin]

Try inserting a value only into what, and then only into when. See what's giving you the error.