Articles tagged with: mariadb
Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
Published Feb 1, 2020 • 3 min read • 0 comments
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]…Read More →