MySQL (8.0.21) drop table tab1;create table tab1(col1 varchar(20)); insert into tab1 values('ABCDEFG');insert into tab1 values('abcdefg'); select * from tab1; select concat('XXXX',substring(col1, 5))into outfile '/tmp/tab1.dmp'fields termi…