当前位置：网站首页>MySQL ERROR: ERROR 1292 (22007) : Incorrect date value: '1988' for column 'birthday' at row 1

MySQL ERROR: ERROR 1292 (22007) : Incorrect date value: '1988' for column 'birthday' at row 1

2022-08-07 12:41:00 【bksheng】

I want to insert a record that contains a date record, but an error is reported.
The reason for the error: When inserting the value of the date data type, quotation marks should be added outside the date.
Error code:

insert into db_student(name,age,sex,span>birthday) values('Zhang San',22,0,2000-12-12span>)

Fixed code:

insert into db_student(name,age,sex,span>birthday) values('Zhang San',22,0,'2000-12-12'span>)
原网站

版权声明
本文为[bksheng]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/219/202208071217038699.html

边栏推荐

猜你喜欢

随机推荐