如何更新单元格值大于n的mySQL表行？

Question

I'm creating a CMS using PHP and as a begginer I ran into a simple problem. In the menu section, I use a table with this information: ID ORDER NAME
ORDER describes in what place will the menu element appear in the menu. While deleting a menu item, I want a script, that will automatically reduce the ORDER number by 1 for all the menu items, that have the order number greater than that deleted item. Could anyone write that for me? Thank you

Answer 1

Is this what you're looking for?

UPDATE table_name
  SET order = order - 1
WHERE order > deleted_item_order_number