如何在mysql [duplicate]中移动所有行代替已删除的行

Question

This question already has an answer here:

• How to fill in the “holes” in auto-incremenet fields? 7 answers

in mysql In a single table i want to delete particular row and remaining row must be comes in place of that particular row along with id... How can i do this??

Id  Name             Title                 order_id     Delete
------------------------------------------------------------------
134 ravi luhar       asp.net developer     1            DELETE
135 ravi luhar       asp.net developer     2            DELETE

</div>

Answer 1

you can process with 2 query. first copy & update 1st row data and then delete second row data.

UPDATE users AS A
      LEFT JOIN users AS B ON B.id = 135
SET A.name = B.name 
     WHERE A.id = 134;

Delete from users where id=135;