要从日期到日期/时间更改数据类型,请使用alter命令。alter table yourTableName change yourColumnName yourColumnName datetime;
让我们首先创建一个表-mysql> create table DemoTable
(
Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
LoginDate date
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable(LoginDate) values('2019-01-21');
mysql> insert into DemoTable(LoginDate) values('2018-05-01');
mysql> insert into DemoTable(LoginDate) values('2017-12-31');
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
输出结果+----+------------+
| Id | LoginDate |
+----+------------+
| 1 | 2019-01-21 |
| 2 | 2018-05-01 |
| 3 | 2017-12-31 |
+----+------------+
3 rows in set (0.66 sec)
以下是在MySQL中将数据类型从日期更改为日期/时间的查询-mysql> alter table DemoTable change LoginDate LoginDate datetime;
Records : 3 Duplicates : 0 Warnings : 0
让我们使用desc命令检查表说明-mysql> desc DemoTable;
输出结果+-----------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| LoginDate | datetime | YES | | NULL | |
+-----------+----------+------+-----+---------+----------------+
2 rows in set (0.19 sec)