LMSouq
database Open

MySQL: How to copy rows, but change a few fields?

AN
Andrew
1 month ago
3 views
Problem Description
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" Now I want to copy all those rows and create new rows while setting the `Event_ID` to `155`. How can I accomplish this?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base