UPDATE

CREATE TABLE devices ( id INT AUTO_INCREMENT PRIMARY KEY, uniqueID int NOT NULL UNIQUE, firstName VARCHAR(100), secondName VARCHAR(100) ); INSERT INTO devices (firstName, secondName)VALUES ('James','Froggatt'); ... now INSERT INTO devices…