In the following MySQL command how many rows will be updated?

UPDATE personSET lname=’s’,Fname=’p’,WHERE person_id<10;/* person_id is a primary key */

UPDATE personSET lname=’s’,Fname = ’p’,WHERE person_id = 1;/* person_id is a primary key */

SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;

INSERT INTO person(person_id, fname,lname)VALUES (1,’S’,’U’),VALUES (1,’T’,’U’);/* where person_id is a primary key */

INSERT INTO person(person_id, fname,lname)VALUES (1,’S’,’U’),VALUES (2,’T’,’U’);/* where person_id is a primary key */

CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);

CREATE TABLE person(person_ id SMALLINT UNSIGNED,fname VARCHAR(20),lname VARCHAR(20),CONSTRAINT pk_person PRIMARY KEY (person_id));

SELECT fname, lname, person_idFROM personWHERE lname=’s’;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

DELETE personWHERE person_id<10;/*person_id is a primary key */

DELETE personWHERE person_id=1;/*person_id is a primary key */

CREATE VIEW person_1 ASSELECT fname, lname, person_id FROM person;