mysql导出sqlolad导入

 

1.导出语句

SELECT
 ifnull(id,'')
,ifnull(replace(replace(replace(trim(icon),char(13),''),char(10),''),'|',''),'')
,deleted+0
,ifnull(version,'')
,ifnull(sync_time,'')
,ifnull(create_time,'')
,ifnull(update_time,'')
into outfile '/home/middle/mysql57/secure_file/vaccine_info.txt'
character set utf8
fields terminated by '|'
FROM tb_test s;