MariaDB クエリの結果をcsvに出力する

select * from テーブル名 into outfile "出力先/ファイル名" fields terminated by ',';

SELECT @@global.secure_file_priv;

<出力結果>
+---------------------------+
| @@global.secure_file_priv |
+---------------------------+
| NULL                      |
+---------------------------+
1 row in set (0.000 sec)

select * from tbl1 into outfile "/tmp/tbl1.csv" fields terminated by ',';

$ cat /tmp/tbl1.csv

<出力結果>
1,taro,10
2,jiro,20
3,saburo,30

select * from tbl1 into outfile "/tmp/tbl1_2.csv" fields terminated by ',' enclosed by '"';

$ cat /tmp/tbl1_2.csv

<出力結果>
"1","taro","10"
"2","jiro","20"
"3","saburo","30"