Untitled

Insert the new record after a exsiting result
shop_vnum   item_vnum   count
4           13209       1
4           11229       1

shop_vnum   item_vnum   count
4           13209       1
4           12400       1
4           11229       1

CREATE VIEW items_view AS SELECT * FROM items ORDER BY item_vnum DESC;

insert into items (shop_vnum, item_vnum, `count`)
values (4, 12400, 1);