INSERT INTO `表2` (`id`, `name`,`time`)
SELECT id,concat(@name,id) as name,time FROM 表1
concat(value1,value2,value3....):连接一个或者多个字符串
表1
+------+----------------+
| id | time |
+------+----------------+
| 1 | 16:03:31 |
+------+----------------+
| 2 | 16:03:32 |
+------+----------------+
| 3 | 16:03:33 |
+------+----------------+
表2
+------+------+---------------------+
| id | name | time |
+------+------+---------------------+
| 1 | 名称1 | 16:03:31 |
+------+------+---------------------+
| 2 | 名称2 | 16:03:32 |
+------+------+---------------------+
| 3 | 名称3 | 16:03:33 |
+------+------+---------------------+