SELECT INTO OUTFILE is used to export query results to file and can be formatted using additional export options. By default, columns are separated by tabs ( \t ) while rows are separated by newlines ( \n ). From the MariaDB documentation, [https://mariadb.com/kb/en/select-into-outfile/](https://mariadb.com/kb/en/select-into-outfile/) sql SELECT ... INTO OUTFILE 'file_name' CHARACTER SET charset_name] export_options] export_options: FIELDS | COLUMNS} TERMINATED BY 'string'] OPTIONALLY]…