Home > Database > Mysql Tutorial > mysql-在MySQL中添加数据用到CURDATE()遇到的问题

mysql-在MySQL中添加数据用到CURDATE()遇到的问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 09:33:14
Original
1141 people have browsed it

mysql

在MySQL中创建Info表后,插入数据显示有错,主要是在addtime的字段上。相关代码如下:
#建表
create table item(
……
addtime date not null,
endtime date not null,
……
#插入数据
INSERT INTO item ( item_name , item_remark , item_desc, kind_id, addtime , endtime, init_price, max_price, owner_id, winer_id, state_id)
VALUES ( '主板', '老式主板', '老主板,还可以用', 1, CURDATE()-5, CURDATE() + INTERVAL 30 DAY , 230, 250, 1, null, 1);

我查了CURDATE()函数可以作为字符串,也可以作为数字上下文被使用,定义为Date类型的例子也有,所以初步觉得代码没问题。
但是在输入后,我的电脑上还是出现了如下错误:
ERROR 1292 (22007):Incorrect date value:'20160398' for column 'addtime' at row 1
求大神指点

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template