Error when creating table

[nasio]

I tried to create the following table:

mysql> CREATE TABLE Members (
-> userid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> email VARCHAR(100) NOT NULL,
-> password VARCHAR(16) NOT NULL,
-> name VARCHAR(100) NOT NULL,
-> country VARCHAR(100) NOT NULL,
-> update VARCHAR(3) NOT NULL,
-> joined DATE NOT NULL
-> );

But I received this error:

ERROR 1064: You have an error in your SQL syntax near 'update VARCHAR(3) NOT NUL
L,
joined DATE NOT NULL
)' at line 7

What am I doing wrong?

[KMxRetro]

Hi there,
I'm not altogether sure about this, but I *THINK* that you cannot use NOT NULL on a DATE field.

Anyone else shed any more light if this doesn't work?

[nasio]

I this article by Kevin Yank

http://www.webmasterbase.com/article.php/228/180

you can see that he is using the NOT NULL on a DATE field.

[KMxRetro]

I never said I was right I very rarely am!

Anyways, I'll have a look into it.

[nasio]

Can no one help me? Where are the MySQL experts that visit this board?

[mickmel]

Are you allowed to use the word "update" for a column name, since it is also the name of a command?

[nasio]

Are you allowed to use the word "update" for a column name, since it is also the name of a command?

Thanks mickmel! I changed the column name "update" to "list" and it worked!