How to Export Data in SQL
To export data from a SQL database, you can use the SELECT … INTO OUTFILE or the SELECT … INTO DUMPFILE clause to write the query results to a file in a specified format. Here are two examples of exporting your data to a file:
Using a SELECT … INTO OUTFILE clause
SELECT column1, column2, ... FROM table_name WHERE condition INTO OUTFILE 'C:/output/data.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
This query will export the columns from the table_name to a file called data.csv in the C:\output directory. You can specify your filter conditions in a WHERE clause if needed.
Using a SELECT … INTO DUMPFILE clause
SELECT column1 FROM table WHERE id = 123 INTO DUMPFILE '/path/to/file.pdf';
If you use Coginiti Pro, you can click “Export” to download the data as a CSV, TSV, or XLSX. It’s also possible to Copy to Clipboard and paste the data where you want.
If you need to change the delimiter and other details, apply your preferences before exporting.
Note that you may need to adjust the file path and column names to match your database schema.