select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order' and COLUMN_NAME not in (select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order_check');
select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order_check' and COLUMN_NAME not in (select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order');
获得表所有字段
select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='cdj_order' GROUP BY COLUMN_NAME;