In the following SQL command "person_id" can be . . . . . . . .

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));

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_date FROM person;

INSERT INTO person(person_id, fname, lname) VALUES (1,’S’,’P’);

CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATECONSTRAINTS pk_person PRIMARY KEY (person_id));INSERT INTO personVALUES( person_id, name, LAST, Birth_date)(1,’s’,’p’, 24-1991-01);

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