先查询一张表
mysql> select * from SALGRADE ;
+-------+-------+-------+
| GRADE | LOSAL | HISAL |
+-------+-------+-------+
| 1 | 700 | 1200 |
| 2 | 1201 | 1400 |
| 3 | 1401 | 2000 |
| 4 | 2001 | 3000 |
| 5 | 3001 | 9999 |
+-------+-------+-------+
创建一张备份表
create table SALGRADE1 like SALGRADE;
insert into SALGRADE1 (GRADE,LOSAL,HISAL)values(6,2020,9999);
insert into SALGRADE1 (GRADE,LOSAL,HISAL)values(7,2220,91999);
查询新表
mysql> SELECT * FROM SALGRADE1
-> ;
+-------+-------+-------+
| GRADE | LOSAL | HISAL |
+-------+-------+-------+
| 1 | 700 | 1200 |
| 2 | 1201 | 1400 |
| 3 | 1401 | 2000 |
| 4 | 2001 | 3000 |
| 5 | 3001 | 9999 |
| 6 | 2020 | 9999 |
| 7 | 2220 | 91999 |
+-------+-------+-------+
对比数据
SELECT GRADE FROM SALGRADE1 WHERE GRADE NOT IN (SELECT GRADE FROM SALGRADE);
+-------+
| GRADE |
+-------+
| 6 |
| 7 |
+-------+
