Hello,

I would like to export a part of my MySQL database as a SQL script. I thought about mysqldump.exe but it's too simple. I need to export rows from one table which matchs simple criteria and all rows from other tables which are in relation with them.

The ideal solution would be to make a SELECT query and pass it to *something*. This *something* would execute the query, analyze found rows and return SQL script creating these rows.

In current project I'm using Hibernate but this part can be done using any tool or pure JDBC.

How would you handle such a task?

Akonet Sp. z o.o. ul. Rozbrat 32/37 00-429 Warszawa