GeniusConnect support forum
GeniusConnect support forum
Home | Profile | Register | Active Topics | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Database
 MySQL
 Dumping BLOB's from MySQL to file
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Admin

Czech Republic
1708 Posts

Posted - 18 May 2020 :  20:51:34  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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/doc/refman/8.0/en/select-into.html

Admin

Czech Republic
1708 Posts

Posted - 19 May 2020 :  10:22:10  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.mysqltutorial.org/import-csv-file-mysql-table/
Go to Top of Page
   Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
GeniusConnect support forum © Copyright (C) 2003 - 2020, GeniusConnect, All Rights Reserved. Go To Top Of Page
Snitz Forums 2000