SQL numeric data field error

[BorgMan]

I have a simple question. I have installed MYSQL version 4.0.12 on my PC running Windows 2000. I am trying to create a table with numeric elements with the following code:

create table checks (check numeric(6) not null);

I get the following error:

Error 1064: You have an error in your SQL syntax.

Can someone direct me as to what I am doing wrong?

 

[sleipnir214]

"check" is a reserved word. It's used in the command "CHECK TABLE" (

http://www.mysql.com/doc/en/CHECK_TABLE.html)

I recommend you pick another column name.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BorgMan]

Thank you. I took that field name straight out of the example in the book I was reading, and it never occured to me that it might be a reserved word.