into outfile 生成sql脚本

select concat('insert into t_dm_stage(STAGE_ID,STAGE_NAME) values(',STAGE_ID,',',''',STAGE_NAME,''',');') into outfile '/tmp/sql.txt'  from t_dm_stage;

会在mysql服务器的/tmp/目录下生成一个sql.txt文件。