SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE products ( id_product int, id_category int, position int, primary key (id_product, id_category) ); INSERT INTO products VALUES (15, 12, 10), (190, 12, 10), (191, 12, 11), (230, 12, 12), (15, 143, 12), (150, 143, 50); SELECT * FROM products; INSERT IGNORE INTO dbo.products SELECT id_product, 143 as id_category, (SELECT MAX(position) FROM products WHERE id_category = 143) + (row_number() over (order by id_product)) as position FROM products WHERE id_category = 12; SELECT * FROM products;