Batch export LOB data

Batch export LOB data example

You have a table pets.

pets table struct

You have data in table pets.

pets table

You want export blob data from table pets.

1. You can export "table".

1) You can enter "Where Clause" if you need.

export pets table

2) And you can specify a "Where List".

The "Where List" pets_where_list.txt is like:

name='cat1'
name='cat2'
name='cat3'

export pets table

The exported cat pictures.

cat folder

2. Or export "query". You need click the "Show Lob Field" button after enter the query.

export pets query

The exported dog pictures.

dog folder

From:	Choice export data from "table" or "query"
Table:	Table to export LOB data
Where Clause:	Where clause for "Table"
Where List:	Where list for "Table"
Query:	Enter a query to export LOB data, you need click the "Show Lob Field" button after enter the query.
LOB Field:	The field store LOB data
File Name:	Determine how to generate file names, can be generated by field, like id, name, etc., or by serial 1, 2, 3 ...
File Extension:	Determine how to generate file extensions, can be generated by field, like image_format, file_extension, etc., or specific one, like "dat"
Save To:	The folder to place LOB files
Sub Folders:	Determine how to create sub folders