USE spchs;

INSERT INTO equipment_master
    (id, equipment_name, display_order, status)
VALUES
    (1, 'Desktop', 1, 'Active'),
    (2, 'Laptop', 2, 'Active'),
    (3, 'Tab', 3, 'Active'),
    (4, 'Smart Board', 4, 'Active'),
    (5, 'Smart TV', 5, 'Active'),
    (6, 'UPS', 6, 'Active'),
    (7, 'Telephone', 7, 'Active'),
    (8, 'Internet', 8, 'Active')
ON DUPLICATE KEY UPDATE
    display_order = VALUES(display_order),
    status = VALUES(status);
