Question

mysql 设置字段默认值为当前时间加5分钟

CREATE TABLE VIDEO.T_US_VERIFY_CODE (
funcid VARCHAR (4),
maketime datetime DEFAULT now(),
msisdn VARCHAR (11) NOT NULL,
overtime datetime DEFAULT DATE_ADD(NOW(),INTERVAL 5 MINUTE) ,
portaltype VARCHAR (4) DEFAULT '2',
verifycode VARCHAR (10),
returncode VARCHAR (50)
)
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATE_ADD(NOW(),INTERVAL 1/24/60*5) ,
portaltype VARCHAR (4) DEFAULT '2',
ver' at line 5

overtime 想设置默认值为当前时间再加上5分钟

Answer 1

CREATE TABLE `test1` (
`a` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`b` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`c` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
建表test1。3个字段 a,b,c

insert into test1 VALUES(NULL,NULL,NULL)
插入的时候设置3字段都是 null

然后成功
Affected rows : 1, Time: 0.00sec