MySQL:如何复制行，但要更改一些字段? [英] MySQL: How to copy rows, but change a few fields?

问题描述

我要复制很多行，但是我需要更改一个字段.

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.

这篇关于MySQL:如何复制行，但要更改一些字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！