Forum OpenACS Q&A: Please help on a Mysql basic issue

Collapse
Posted by Alex Val on
In a unix/apache server, through a web-interface
I tried to define a table and get the following,
can you tell me where's the error?

Do you know what's wrong with this?
Thanks
Alex

---------------------------------------------------
Database test2 - table table1
Error
SQL-query :
CREATE TABLE `table1` (`tkey` INT(4) NOT NULL AUTO_INCREMENT, `tdate` DATE(10) NOT NULL, `ttext` CHAR(60) NOT NULL, INDEX (`tkey`))

MySQL said:
You have an error in your SQL syntax near '(10) NOT NULL, `ttext` CHAR(60) NOT NULL, INDEX (`tkey`))' at line 1
----------------------------------------------------