mysql creating a table with row for a date?

Rickey Vrieze: date() is a FUNCTION!and "date" is a keyword... (so are user, desc, time etc)Use:`date` DATE NOT NULL DEFAULT '0000-00-00',(note the reversed quotes around `date`)or, better, use another word for date, ie "datum".`datum` DATE NOT NULL DEFAULT '0000-00-00',Usefull to set up a default value, here YYYY-MM-DD, an easy ordering method....Show more

Jestine Osumi: Date() is method it not recognize type, so don't use date with DATE()

Antone Youla: DATE() --> datetime

Oscar Wieland: So that can be a table, with container: identity -- purely a recognition style: int(11) -- the fee must be a huge decision (11 digits or much less) Null: Is the fee null or no longer Key: i'm uncertain Default: the default is null yet considering the fact that motor vehicle-increment is desperate, that is going to be crammed in immediately besides with each insert