Administrator
  •  Admin
  • Advanced Member Topic Starter
2020-05-18T20:51:00Z
SELECT ... INTO DUMPFILE writes a single row to a file without any formatting.


Example:
SELECT myBlobColumn  INTO DUMPFILE '/extract/myFile.csv'  FROM myBlobs WHERE id = 100

More info:
https://dev.mysql.com/do.../8.0/en/select-into.html 
Administrator
  •  Admin
  • Advanced Member Topic Starter
2020-05-19T10:22:00Z
extracting csv contents to mysql table, example:

LOAD DATA INFILE 'c:/tmp/discounts.csv'  INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

More info:
https://www.mysqltutoria...rt-csv-file-mysql-table/ 
Similar Topics