MySQL: Export table containing columns of type BLOB using the function LOAD_FILE -


how (or tool) can export data table blob type fields so, there sql script

insert table (id, image) values (1, load_file('dir/image_1'))  insert table (id, image) values (2, load_file('dir/image_2'))  insert table (id, image) values (3, load_file('dir/image_3')) ... 

instead of

insert table (id, image) values (1, '0x89504e470d0a1a....')  insert table (id, image) values (2, '0xffd8ffe000104a....')  insert table (id, image) values (3, '0xffdd0a1004e470....') ... 

and set of files (dir/image_1, dir/image_2,...) received each blob in output.


Comments

Popular posts from this blog

php - Wordpress: Link a post to posts of another category manually -

delphi xe7 upload/download dropbox file using the rest client and show progress -

java - Get more than One value and display it -