Hi Martijn,

last time I checked dbworkbench doesn't run on unix :)

Thanks for the string construction idea

2008/7/31 Martijn Tonies <m.tonies@...>

> Hello Nick,
>
> > before I start thinking about writing something that does this, is anyone
> > aware of one that already exists.
> >
> > I want to do "select a,b from mytable where c < 97" and have the output
> as
> > insert statements, automatically, on unix (fedora 8 to be precise)
>
> Well, a tool like Database Workbench could do that for you :-)
>
> As a workaround, you could also write:
>
> SELECT 'INSERT INTO mytable (a, b) VALUES (' || A || ', ' || B || ');'
> from mytable where c < 97
>
> Export the resultset to file and you should have your script.
>

[Non-text portions of this message have been removed]