Web Hosting Talk







View Full Version : can't create table called "when" with MySQL 3.23.37


dico
11-17-2002, 06:36 PM
I am unable to create a table called 'when' with MySQL 3.23.37. It gives me an error when I try. If I call it 'when-something' then rename the table back to 'when' it will successfully rename. However i still can't search that table.

Is this because 'when' is on a "bad" list or something?

Can I get around this?

Thanks,

-dr

chet
11-17-2002, 07:51 PM
Nope. It is a really bad idea anyways,makes code hard to read. Here is the complete list.

http://www.mysql.com/doc/en/Reserved_words.html

Chet