What is the error in this code?

Question

I'm trying to create a table in MySQL, where the server and MySQL are working fine. I select my DB and I enter the command:
CREATE TABLE fechas (
ID int NOT NULL,
Dia int NOT NULL,
Mes(10) NOT NULL,
Anho int NOT NULL,
PRIMARY KEY(ID)
);
I get:
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 '(10) NOT NULL, 
Anho int NOT NULL,
PRIMARY KEY(ID)
)' at line 6
Can anyone help me?

Answer 1

You need to change Mes(10) to Mes nvarchar(10) like the following.
CREATE TABLE fechas (
ID int NOT NULL,
Dia int NOT NULL,
Mes nvarchar(10) NOT NULL,
Anho int NOT NULL,
PRIMARY KEY(ID)
);