SELECT bbb_id
INTO OUTFILE 'c:/bbb_isnotnull_list.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
FROM v_tmp
WHERE bbb_id IS NOT NULL
;
SELECT bbb_id
INTO OUTFILE 'c:/bbb_isnotnull_list.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
FROM v_tmp
WHERE bbb_id IS NOT NULL
;