mySQL table loses column structure when exported as CSV format
154
December 26, 2017, at 7:08 PM
I am trying to export a table from MariaDB to a folder in CSV format. In MariaDB program, I entered the query: MariaDB [testdatabase]> SELECT * from datatable into outfile '/tmp/exportf.csv'; I then managed to locate this exported file. However, on opening the csv file with Excel, I find that the data are all clustered onto one column. These should be organised into 7 columns. How can I modify my query to avoid this issue?
Answer 1
try this,
SELECT * from datatable into outfile '/tmp/exportf.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' ;
POPULAR ONLINE
- search for elements in a list 105335 visits
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 97549 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 93633 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 91035 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 87834 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 56320 visits
- Adding methods to es6 child class 20088 visits
