MySQL:如何复制行,但要更改一些字段?
问题描述:
我要复制很多行,但是我需要更改一个字段.
I have a large number of rows that I would like to copy, but I need to change one field.
我可以选择要复制的行:
I can select the rows that I want to copy:
select * from Table where Event_ID = "120"
现在,我想复制所有这些行并在将Event_ID
设置为155
的同时创建新行.我该怎么做?
Now I want to copy all those rows and create new rows while setting the Event_ID
to 155
. How can I accomplish this?
答
INSERT INTO Table
( Event_ID
, col2
...
)
SELECT "155"
, col2
...
FROM Table WHERE Event_ID = "120"
col2,...代表表中其余的列( Event_ID以外的列).
Here, the col2, ... represent the remaining columns (the ones other than Event_ID) in your table.