Why wont this work?

[Ronald Rowell]

I know it has to be because of use of a reserved word, the book I have says this should work, but it does not

CREATE TABLE checks
('check' varchar(20) not null);

I do it this way and it works:

CREATE TABLE checks
('checks' varchar(20) not null);

it creates the table, I thought 'check' in quotes would tell mysql its not the reserved word CHECK ???

Thanks for being patient with the probably asked already asked question, but I could not find it in the wealth of information on the great site...