A、Smith和John玩数字匹配游戏,每个人选择1、2、3,如果数字相同,John给Smith3美元,如果不同,Smith给John1美元。
A、INSERT INTO employees VALUES (NULL, 'John', 'smith'); B、INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith'); C、INSERT INTO employees VALUES ('1000, 'John', 'smith'); D、INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith'); E、INSERT INTO employees (employee_id) VALUES (1000); F、INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');
A、INSERT INTO employees VALUES (NULL, 'John', 'smith'); B、INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith'); C、INSERT INTO employees VALUES ('1000, 'John', 'smith'); D、INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith'); E、INSERT INTO employees (employee_id) VALUES (1000); F、INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');
A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180; B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180; C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180; D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;
A、A. INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’); B、B. INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’); C、C. INSERT INTO employees VALUES (‘1000’,‘John’,NULL); D、D. INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’); E、E. INSERT INTO employees (employee_id) VALUES (1000); F、F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
A、INSERT INTO employees VALUES ( NULL, 'John', 'Smith'); B、INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith'); C、INSERT INTO employees VALUES ( '1000', 'John', NULL); D、INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith'); E、INSERT INTO employees (employee_id) VALUES (1000); F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith'); B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith'); C、INSERT INTO employees VALUES ('1000','JOHN','NULL'); D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith'); E、INSERT INTO employees (employee_id) VALUES (1000); F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");
A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith'); B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith'); C、INSERT INTO employees VALUES ('1000','JOHN','NULL'); D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith'); E、INSERT INTO employees (employee_id) VALUES (1000); F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");