Articles tagged with: mariadb

Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
Published Feb 1, 20203 min read0 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 →
Copyright © 2017-2023   Mark Brody | Blog