Another MySql Problem

[mark27uk3]

Hi Guys,

 

Can anyone tell me why an error is given why trying to execute this sql

 

DROP TABLE IF EXISTS visual_verify_code;
CREATE TABLE visual_verify_code (
 oscsid varchar(32) NOT NULL,
 code varchar(6) NOT NULL,
 dt TIMESTAMP(12) NOT NULL DEFAULT 'CURDATE()',
 PRIMARY KEY (oscsid)

 

Thanks

 

Mark :thumbsup:

[Jack_mcs]

You're missing a closing bracket for one. If that is not it, you could try posting the error too.

 

Jack