2 DML插入(insert)修改(update)删除(delete)-----测试题

DML:增删改查

1.运行以下脚本创建表my_employees

USE myemployees;
CREATE TABLE my_employees(
id INT(10),
first_name VARCHAR(10),
last_name VARCHAR(10),
userID VARCHAR(10),
salary DOUBLE(10, 2)
);

CREATE TABLE users(
id INT,
userid VARCHAR(10),
department_id INT
);

2.显示表my_employees的结构

DESC my_employees;

3.向my_employees表中插入下列数据【一次性插入多行数据】

id first_name last_name userID salary
1 patel Ralph Rpatel 895
2 Dancs Betty Bdancs 860
3 Biri Ben Bbiri 1100
4 Newman Chad Cnewman 750
5 Ropeburn Audrey Aropeburn 1550

方式一：支持子查询，可以多行插入

INSERT INTO my_employees
VALUES(1, ‘patel’, ‘Ralph’, ‘Rpatel’, 895),
(2, ‘Dancs’, ‘Betty’, ‘Bdancs’, 860),
(3, ‘Biri’, ‘Ben’, ‘Bbiri’, 1100),
(4, ‘Newm