Better export grid rows

[expired user #8737]'s profile image [expired user #8737] posted 9 years ago in General Permalink
When I need to make changes to a table for some specific testing, I sometimes like to save the columns for the rows I am editing. I'd like to be able to run a query that selects those rows, the primary key column and the data columns I will edit.

Then, I'd like to be able to export those rows as "update" statements (since I have included the primary key). It would be create if the "replace" option would see that not all rows in the table are selected, and instead of using "replace", would instead use "update" with the primary key in the where clause, and update the values in all the data columns.

Please login to leave a reply, or register at first.