Dumping BLOB's from MySQL to file

Welcome Guest! To enable all features please Login or Register.

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

Sponsor

GeniusConnect documentation search (User Manual Downloads...)

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;

The GeniusConnect support uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close