MySQL create table problem

I'm trying to create a table with a date column. Here is the code I'm using:

CREATE TABLE clicks 
(
X varchar(15),
Y varchar(15),
ClickDate date(yyyy-mm-dd)
)

Code (markup):

It wasn't working as part of my php script so I put the above inserted directly to the SQL query on phpmyadmin to see the error. Here is the error I got:

Without the date part it works fine. What's the problem

thanks in advance

 

Try using in uppercase: YYYY-MM-DD

 

Just use date instead of date(yyyy-mm-dd). It will by defualt use yyyy-mm-dd format.

CREATE TABLE clicks 
(
X varchar(15),
Y varchar(15),
ClickDate date)

Code (markup):

Kailash

 

The code suggested by Kailash i always used in this type of coding and it works.