mysql 创设timestamp类型字段出错

mysql 创建timestamp类型字段出错

create table test

(

 id int primary key,

 name varchar(20),

 createDate timestamp(14)

)

ERROR 1426 (42000): Too big precision 14 specified for column ‘createDate’. Maxi

mum is 6.

timestamp类型，不要指定长度




create table test

(

id int primary key,

name varchar(20),

createDate timestamp

)