LMSouq
database Open

How to copy a row and insert in same table with a autoincrement field in MySQL?

NA
Navdroid
1 month ago
3 views
Problem Description
In MySQL I am trying to copy a row with an **autoincrement** `column ID=1` and **insert** the data into same table as a new row with `column ID=2`. How can I do this in a single query?

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