在编辑MySql进行更改日期时报错,代码如下
mysql> insert into date values ('zhangsan',92-01-02,99-03-04);
ERROR 1292 (22007): Incorrect date value: '89' for column 'birth' at row 1
更改为
mysql> insert into date values ('zhangsan',19920102,19990304);
Query OK, 1 row affected (0.13 sec)
成功。
相关文章
- MySql 报ERROR 1292 (22007) 故障
- ERROR 1292 (22007): Incorrect datetime value: ‘2002‘ for column ‘出版日期‘ at row 1
- Gorm : Error 1292 (22007): Incorrect datetime value: ‘0000-00-00‘ for column ‘login_time‘ at row 1
- ERROR 1292 (22007): Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘created_on‘ at row 1
- MYSQL启动后报:ERROR! The server quit without updating PID file错误
- MYSQL启动后报:ERROR! The server quit without updating PID file错误的问题解决
- [MySQL] error 1292 数据类型错误
- 黄聪:xampp启动后mysql报Error
- 远程连接centos7 上的mysql报(ERROR 2003 (HY000): Can't connect to MySQL server on '168.x.x.x' (10060) )
- mysql数据库报ERROR 104错误解决