The "," is required before the PRIMARY KEY declaration.
It fails without it.
Removing the "," before the CHECK declaration simply generates a similar
error sooner:
ERROR 1064: You have an error in your SQL syntax near 'CHECK (max_sched
REGEXP "[0-9]")) TYPE=Innodb;'
v> From create syntax, you can
From create syntax, you cannot put , after VARCHAR(1). You have another ,
after AUTO_INCREMENT, maybe it is not correct too.
At 01:56 PM 7/31/2002 -0400, Larry Irwin wrote:
>Using MySQL 4.02 on SuSE Linux 7.3
>The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
>CHECK (ex
