一、单个卸数脚本示例
select
`SerialNo`,
`CustomerId`,
`OccurDate`,
`RuleId`,
`ChangeContext`
from info_change into outfile
'/home/mysqldata/mysql_dump/files/info_change.txt'
character set utf8mb4 fields terminated by x'0f' enclosed by '\"' lines terminated by '\n';
二、数据文件加载示例
先删除、后导入文件
delete from info_change;
load data local infile '/home/mysqldata/mysql_dump/files/info_change.txt'
into table auth_info_change
fields terminated by x'0f' enclosed by '\"' lines terminated by '\n';
select count(1) as info_change_count from info_change;
三、mysql控制台卸数执行命令
使用 local-infile参数,表示从文件导入
mysql -udb_admin -pdb@123 --socket=/home/mysqldata/mysql_3306/data/mysqld.sock --local-infile