mysql 一组数组中，找出数据里没有的值。

1

SELECT code FROM (

SELECT '210A' as code
UNION
SELECT '2117' as code
UNION 
SELECT '2126' as code
UNION
SELECT '2131' as code
) a WHERE code NOT IN 
(
SELECT code from ke_hu WHERE code IN 
('210A',
'2117',
'2126',
'2131')

);

2

CREATE TEMPORARY TABLE temp_table3 (code varchar(32));


INSERT INTO temp_table3 VALUES ('210A'); 
INSERT INTO temp_table3 VALUES ('2117'); 
INSERT INTO temp_table3 VALUES ('2126'); 
INSERT INTO temp_table3 VALUES ('2131'); 


SELECT CODE FROM temp_table3
WHERE code NOT IN (
SELECT code from ke_hu WHERE code IN 
('210A',
'2117',
'2126',
'2131')
);