ADD TABLE employee { f_employeeid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT f_username VARCHAR(15) NULL f_password VARCHAR(15) NULL f_firstname VARCHAR(255) NULL f_lastname VARCHAR(255) NULL PRIMARY KEY[f_employeeid] UNIQUE [f_username] } INSERT INTO employee (username, password, firstname, lastname) VALUES('john' 'secret' 'John' 'Doe') INSERT INTO employee (username, password, firstname, lastname) VALUES('jim' 'secret' 'Jim' 'Jones') SELECT ALL FROM employee WHERE firstname=John; UPDATE employee f_lastname='Green' WHERE f_lastname='Jones'