Large Datasets Development Tutorials, Guides & Insights
Unlock 1+ expert-curated large datasets tutorials, real-world code snippets, and modern dev strategies. From fundamentals to advanced topics, boost your large datasets skills on DeveloperBreeze.
Adblocker Detected
It looks like you're using an adblocker. Our website relies on ads to keep running. Please consider disabling your adblocker to support us and access the content.
Data Import and Export in MySQL
Tutorial August 12, 2024
mysql
To export data from a table to a CSV file, use the SELECT INTO OUTFILE statement:
SELECT * FROM your_table_name
INTO OUTFILE '/path/to/export.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';