SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE inventory_player ( id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL, item_id int(11) NOT NULL, slot_id int(11) NOT NULL, deleted_at_time datetime DEFAULT NULL, PRIMARY KEY (id) ); INSERT INTO inventory_player (user_id, item_id, slot_id, deleted_at_time) VALUES (4, 0, 0, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 0, 1, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 0, 2, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 0, 3, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 1, 4, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 1, 4, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 1, 4, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))), (4, 1, 4, IF(-1 = -1, NULL, FROM_UNIXTIME('-1'))); SELECT * FROM inventory_player; UPDATE inventory_player inv_plr_1 INNER JOIN inventory_player inv_plr_2 ON inv_plr_1.id != inv_plr_2.id SET inv_plr_1.item_id = inv_plr_2.item_id, inv_plr_1.deleted_at_time = inv_plr_2.deleted_at_time, inv_plr_1.slot_id = inv_plr_2.slot_id WHERE inv_plr_1.slot_id IN (4, 2) AND inv_plr_2.slot_id IN (4, 2) AND inv_plr_1.user_id = 4 AND inv_plr_2.user_id = 4; SELECT * FROM inventory_player;