Creating table not working

[blackman890]

Hi guys, stupid question here:

why isn't the following working in MySql:

mysql> CREATE TABLE programming (
    -> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> name TINYTEXT,
    -> desc TEXT,
    -> files INT NOT NULL); 

I always get the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc TEXT,
files INT NOT NULL)' at line 4 

Please tell me what is wrong as I cant see it fully

[Toly]

Because 'desc' is a reserved word in MySQL. Try using a different name like 'description'.

[blackman890]

thanks, it is working now