drop table if exists t1;
create table t1 (`a` blob);
insert into t1 values("hello world"),("Hello mars"),(NULL);
select load_file(concat(@tmpdir,"/outfile-test.1"));
load_file(concat(@tmpdir,"/outfile-test.1"))
hello world
Hello mars
\N

select load_file(concat(@tmpdir,"/outfile-test.2"));
load_file(concat(@tmpdir,"/outfile-test.2"))
hello world
select load_file(concat(@tmpdir,"/outfile-test.3"));
load_file(concat(@tmpdir,"/outfile-test.3"))
 
select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
load_file(concat(@tmpdir,"/outfile-test.not-exist"))
NULL
drop table t1;
select load_file(concat(@tmpdir,"/outfile-test.4"));
load_file(concat(@tmpdir,"/outfile-test.4"))
1

CREATE TABLE t1 (a INT);
EXPLAIN 
SELECT *
INTO OUTFILE '/tmp/t1.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
  FROM t1;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	system	NULL	NULL	NULL	NULL	0	const row not found
DROP TABLE t1;