一、需求
有两个表格,test和test2如下所示:
mysql> select * from test;
+------+------+------------+
| data | id | timestamp |
+------+------+------------+
| 300 | 3 | 1536292800 |
| 200 | 2 | 1536292808 |
+------+------+------------+
mysql> select * from test2;
+------+------+
| data | id |
+------+------+
| 10 | 3 |
| 20 | 2 |
+------+------+
1. 需求A
在test表格上直接操作,增加一列为context_time,数据类型为datetime,并赋值为对应的行的UNIX time的datetime,如下表所示(可以延伸为对每一行的某个字段进行相同的运算或函数操作后赋值到新的字段):
+------+------+------------+---------------------+
| data | id | timestamp | context_time |
+------+------+------------+---------------------+
| 300 | 3 | 1536292800 | 2018-09-07 12:00:00 |
| 200 | 2 | 1536292808 | 2018-09-07 12:00:08 |
+------+------+------------+---------------------+
2. 需求B
将表格test2中的data字段查询出来后根据id拼接到test表格后面,字段名为new_data,如下所示:
+------+------+------------+---------------------