Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Samuel Poole: "I recently downloaded and ordered MySQL Data Wizard, and I thought I would drop you a note to let you know that it is the software I needed . Well done, keep up the good work, and please accept my very best regards. Please feel free to use the contents of this e-mail along with my name, as an endorsement of your excellent product".
Jeff Johnson: "Thanks for your help. I'm a big fan of your software. It's very useful".

More

Add your opinion

Data Wizard for MySQL online help

Prev Return to chapter overview Next

Setting files for import

To load BLOB files, specify the file name template using filed name tags (i.e. %id%, %user%, where 'id' and 'user' are the fact table columns).

 

Example:

Suppose we have a table 'employee' with Non-Blob data as follows:

Id       User

1        Max

2        July

To import D:\Data\1.jpg and D:\Data\2.jpg to a BLOB column of the table, specify D:\Data as directory name and %Id%.jpg as file name template.

 

 

You can define the default root directory with %root_dir%, %table_name%, and %field_name% tags.

 



Prev Return to chapter overview Next