Alex Rivera | Logout

MySQL syntax for inserting a new row in middle rows?

Asked 2011-06-13T16:57:18.563
28

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.

Edit
Report

1 Answer

0
insert into my_table (value)
values (select value+100 from my_table order by id desc limit 1)
answered 2011-06-13T16:59:36.917

Your Answer