全部列数【65条】
不存在的列(22条)
SELECT a.*
FROM test_unit a
WHERE NOT EXISTS (
SELECT b.`name`
FROM tra_unit b
WHERE a.name = b.name
);
存在的列,以及其他列信息(43条)
SELECT t2.name,t2.id FROM `test_unit` t1 INNER JOIN tra_unit t2 on t1.name = t2.name
标签:存在,name,表中,t2,SELECT,mysql,unit From: https://www.cnblogs.com/lcaiqin/p/18562420