将日期和时间从单独的列连接到MySQL中的单个列
为此，使用CONCAT()方法连接日期和时间。让我们首先创建一个表-
mysql> create table DemoTable -> ( -> ShippingDate date, -> ShippingTime time, -> ShippingDatetime datetime -> );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable(ShippingDate,ShippingTime) values('2019-01-10', '10:40:20');
mysql> insert into DemoTable(ShippingDate,ShippingTime) values('2019-06-14', '04:00:10');使用select语句显示表中的所有记录-
mysql> select *from DemoTable;
输出结果
+--------------+--------------+------------------+ | ShippingDate | ShippingTime | ShippingDatetime | +--------------+--------------+------------------+ | 2019-01-10 | 10:40:20 | NULL | | 2019-06-14 | 04:00:10 | NULL | +--------------+--------------+------------------+ 2 rows in set (0.00 sec)
这是将日期和时间从单独的列连接到MySQL中的单个列的查询-
mysql> update DemoTable set ShippingDatetime=concat(ShippingDate,' ',ShippingTime); Rows matched: 2 Changed: 2 Warnings: 0
让我们再次检查表记录-
mysql> select *from DemoTable;
输出结果
+--------------+--------------+---------------------+ | ShippingDate | ShippingTime | ShippingDatetime | +--------------+--------------+---------------------+ | 2019-01-10 | 10:40:20 | 2019-01-10 10:40:20 | | 2019-06-14 | 04:00:10 | 2019-06-14 04:00:10 | +--------------+--------------+---------------------+ 2 rows in set (0.00 sec)