SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE dashboards ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, company_id INT NULL, `order` TINYINT(1) DEFAULT 0 NOT NULL ); INSERT INTO dashboards (id, company_id, `order`) VALUES (1, 32323001, 0); INSERT INTO dashboards (id, company_id, `order`) VALUES (2, 32323001, 0); INSERT INTO dashboards (id, company_id, `order`) VALUES (3, 32323001, 0); INSERT INTO dashboards (id, company_id, `order`) VALUES (4, 32323999, 0); INSERT INTO dashboards (id, company_id, `order`) VALUES (5, 32323001, 0); INSERT INTO dashboards (id, company_id, `order`) VALUES (6, 32323001, 0); INSERT INTO dashboards (id, company_id, `order`) VALUES (7, 32323001, 0); INSERT INTO dashboard VALUES (1, 32323001, 1), # update with correct company_id (8, 32323001, 1), # create (4, 32323001, 1) # update even if company_id is not correct ON DUPLICATE KEY UPDATE `order` = VALUES(`order`); SELECT * FROM dashboards;