KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
mysql sintax for insert a new row in middle rows or wherever we want without updating the existing row, but automatically increment the primary key (id)? ' id | value ' 1 | 100 ' 2 | 200 ' 3 | 400 ' 4 | 500 I want to insert a new row after id 2, with a value = 300. I want the output as below: ' id | value ' 1 | 100 ' 2 | 200 ' 3 | 300 <-- new row with id (automatic increment) ' 4 | 400 <-- id=id+1 ' 5 | 500 <-- id=id+1 Thanks.
Tags (comma-separated)
Save Edits
Cancel