我有一个名为workerTab的表:
| Id | Name | Age | Cityid |
| ---| ---- | --- | --- |
| 1| John | 22 | 5 |
| 2| Adam | 34 | 5 |
| 3| Eve | 19 | 5 |
我希望在列中有:Build,插入将重建/填充我的表的查询.
SELECT *
,CONCAT (
'INSERT INTO workerTab(id,name,Age,Cityid)
VALUES(1, ''John'', 22, 5),'
,'(2, ''Adam'', 34, 5), '
,'(3, ''Eve'', 19, 5)'
) as Build
from workerTab
where cityid = 5
这就是我得到的:
Id | Name | Age | Cityid | Build |
---|---|---|---|---|
1 | John | 22 | 5 | INSERT INTO workerTab(id,name,Age,Cityid) VALUES(1, 'John', 22, 5),(2, 'Adam', 34, 5), (3, 'Eve', 19, 5) |
2 | Adam | 34 | 5 | INSERT INTO workerTab(id,name,Age,Cityid) VALUES(1, 'John', 22, 5),(2, 'Adam', 34, 5), (3, 'Eve', 19, 5) |
3 | Eve | 19 | 5 | INSERT INTO workerTab(id,name,Age,Cityid) VALUES(1, 'John', 22, 5),(2, 'Adam', 34, 5), (3, 'Eve', 19, 5) |
我想为每一行使用列内构建插入命令.例如:
Id | Name | Age | Cityid | Build |
---|---|---|---|---|
1 | John | 22 | 5 | INSERT INTO workerTab(id,name,Age,Cityid) VALUES(1, 'John', 22, 5) |
2 | Adam | 34 | 5 | INSERT INTO workerTab(id,name,Age,Cityid) VALUES(2, 'Adam', 34, 5) |
3 | Eve | 19 | 5 | INSERT INTO workerTab(id,name,Age,Cityid) VALUES(3, 'Eve', 19, 5) |
我只是被卡住了,无法完成.