Multiple inserts

General usage of Access to MySQL

Moderator: jr

ukuser
Posts: 1
Joined: Mon Apr 23, 2007 1:35 pm

Multiple inserts

Post by ukuser »

Hi,

Can I just say - thanks for producing the program & its great to see it free!

I have a suggestion regarding multiple inserts.

At the moment, a dump file (and I'm not sure about the direct transfer), does the following:

INSERT INTO table VALUES (1,2,3);
INSERT INTO table VALUES (1,2,3);
INSERT INTO table VALUES (1,2,3);

However this obviously repeats the INSERT phrase and for a large file or transfer can take quite a long time. In MySQL it is possible to do the following (pos just MySQL 5?):
(See http://dev.mysql.com/doc/refman/5.0/en/insert.html for reference)

INSERT INTO table VALUES
(1,2,3),
(1,2,3),
(1,2,3)

For a rough idea - the top 3 lines are 103 bytes and the lower lines are 53 bytes - clearly a huge reduction and for a large scale import this would drastically speed up the time.

If it was able to include this feature, it would be superb.

Many thanks

Antony