Tom Tom - 1 year ago 98
MySQL Question

Looking for a Toad for oracle feature in mysql

Does anyone know any free tools that will generate insert statements given a result set? I know TOAD for Oracle does it, i would need this for a mysql database.

For example, if I execute this query

select colA, colB from mytable where colC = 'numbers'; //returns many rows


|colA | colB |
|1 | 'one' |
|2 | 'two' |
|3 | 'three|


I would be able to get

insert into mytable (colA, colB) values (1,'one');
insert into mytable (colA, colB) values (2,'two');
insert into mytable (colA, colB) values (3,'three');

Answer Source

There is a MySQL version of TOAD. It probably has the same ability to export result sets.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download