【SQL】利用sql语句在mysql的表中插入date类型的数据，

2024-01-07 21:37| 来源: 网络整理| 查看: 265

文中可能有错，请谨慎实施

一. 创建一个数据库

create database test

二. 在数据库中创建表

create TABLE employees (emp_no int(4) not null,birth_date date not null,first_name varchar(14) not null,last_name varchar(16) not null,gender char(1) not null,hire_dare date not null,primary key (emp_no));

三. 表结构

四. 插入记录

mysql> insert into employees values(2,1998-07-14,'li','bc','w',2019-02-21); Query OK, 1 row affected, 2 warnings (0.00 sec)

可以看到有告警

五. 查看表内容

mysql> select * from employees; +--------+------------+------------+-----------+--------+------------+ | emp_no | birth_date | first_name | last_name | gender | hire_dare | +--------+------------+------------+-----------+--------+------------+ | 1 | 0000-00-00 | mai | yp | m | 0000-00-00 | | 2 | 0000-00-00 | li | bc | w | 0000-00-00 |

插入date类型的字段失效

六. 解决：加单引号

mysql> insert into employees values(3,1998-07-14,'li','bc','w',20190211); ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY' mysql> insert into employees values(4,1998-07-14,'li','bc','w',‘20190211’); Query OK, 1 row affected, 1 warning (0.05 sec) mysql> select * from employees; +--------+------------+------------+-----------+--------+------------+ | emp_no | birth_date | first_name | last_name | gender | hire_dare | +--------+------------+------------+-----------+--------+------------+ | 1 | 0000-00-00 | mai | yp | m | 0000-00-00 | | 2 | 0000-00-00 | li | bc | w | 0000-00-00 | | 3 | 0000-00-00 | li | bc | w | 0000-00-00 | | 4 | 0000-00-00 | li | bc | w | 2019-02-11 | +--------+------------+------------+-----------+--------+------------+ 4 rows in set (0.00 sec)

参考：https://blog.csdn.net/lycyl/article/details/45689163

【本文地址】

公司简介

联系我们