create database MyDB_three charset utf8;
select * from 表名 where 查询条件
delete 表名 where 删除条件
insert into 表名(字段1,字段2,……) values('值1','值2',……)
update 表名 set 字段名=新值 where 修改条件
SQL UNION ALL 语法
SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;
SELECT empno, ename, sal
FROMT emp4 WHERE EXISTS (
SELECT * FROMT
salgrade
WHERE sal BETWEEN losal AND hisal
LAND grade IN(3, 4)
)