Equivalent of SQL loader in MySQL

Question

I have found SQL loader in Oracle is very helpful, fast and efficient. What is the MySQL equivalent of SQL loader?

Louis · Accepted Answer · 2011-09-26 12:09:17Z

5

There is MySQL Front 3.2

and

LOAD DATA INFILE

(see docs)

answered Sep 26, 2011 at 12:09

Louis

2,9012 gold badges21 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Suleman Ahmad Over a year ago

Louis: it seems just like external table, Yeah I have tried but any suggestion please for sqlloader ?

Louis Over a year ago

@Suleman : Also called heidiSQL : roseindia.net/mysql/mysql-front.shtml It is a solid tool to interact with the db. Also does import/export of text files, CSV files, ....

symcbean · Accepted Answer · 2011-09-26 12:12:43Z

2

LOAD DATA INFILE....

Provides much of the same functionality as you would implement in your control file except for byte ranges and 'WHERE' filters.

answered Sep 26, 2011 at 12:12

symcbean

48.4k6 gold badges64 silver badges99 bronze badges

Collectives™ on Stack Overflow

Equivalent of SQL loader in MySQL

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related