[REQ] Add a preference or some template mechanism for the "Copy as SQL INSERT" function

[GoogleCodeExporter]

From my table, the copy puts this onto the clipboard:
INSERT INTO `map_users_to_roles` (`user_id`,`role_id`)
VALUES
    (9001, 101),
    (9001, 103),
...

followed by another block.

I need the equivalent of mysqldump's --skip-extended-insert so each line is 
independent of the other.

Perhaps this could be the start of a report templating feature so we could make 
a copy template that would be aware of the number of records to batch up within 
a single insert statement but for now, having the long form insert would 
brilliant.

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?
0.9.8
build 2210

5.1.47
Please provide any additional information below.

Original issue reported on code.google.com by gger...@gmail.com on 28 Jul 2010 at 7:15

[GoogleCodeExporter]

Original comment by stuart02 on 30 Jul 2010 at 10:05

• Changed title: [REQ] Add a preference or some template mechanism for the "Copy as SQL INSERT" function
• Added labels: Component-Logic, Milestone-Release1.0, Priority-Medium, Type-Enhancement, Usability

[GoogleCodeExporter]

This can be achieved using the new export interface available in the nightlies 
and will be included in the 0.9.9 release. 

To achieve the above, simply filter the table to whatever you want to export, 
export the result as SQL and specify how often in terms of rows (or bytes) a 
new SQL INSERT statement should be cerated.

Original comment by stuart02 on 19 Sep 2010 at 11:27

• Changed state: WontFix