K
Konrad Billewicz
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?
--
Best regards,
Konrad Billewicz
Akonet Sp. z o.o.
ul. Rozbrat 32/37
00-429 Warszawa
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?
--
Best regards,
Konrad Billewicz
Akonet Sp. z o.o.
ul. Rozbrat 32/37
00-429 Warszawa