homehome previousprevious nextnext
 
Selecting Import Mode (Step 7)

Select the import mode that define how the data being imported.

Hint: To activate the remaining options, you must enable Primary Key in Step 6.



Advanced

Use entended insert statements
Inserts records using extended insert syntax.

Example:
INSERT INTO `users` VALUES ('1', 'Peter McKindsy', '23'), ('2', 'Johnson Ryne', '56'), ('0', 'Katherine', '23');

Use empty string as NULL
Imports NULL value if the source data field contains empty string.

Use Foreign Key constraint
Adds foreign key if there is foreign key relations between tables.

Continue on errors
Ignores errors that are encountered during the import process.


 

 

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.