New feature: Search + replace on table rows
| User, date | Message |
|---|---|
|
Written by ansgar
4 months ago Category: News 3966 posts since Fri, 07 Apr 06 |
Most HeidiSQL users have used the search/replace dialog. From now on, this dialog does not only support searching in a query editor, but also in data grids and query result rows! An interesting new feature for users who avoid writing UPDATE queries. And of course for those who want the power of regular expressions with callbacks when modifying table rows. Thanks to klorinczi for the idea! |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
I would suggest another dropdown, under 'blue' ('Search in:')one. That would be enabled if 'data grid' would be selected and would contain list of columns in grid, like (as per attached image): All (default) proc_id debug_otput ....  Ok there is workaround = change query to contain only column which you want to mod by regex, but that is not handy. |
|
Written by ansgar
4 months ago 3966 posts since Fri, 07 Apr 06 |
That would duplicate the column selection, and I think the dialog is already crowded enough for such simple search stuff. |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
Hmm, was not avare that sorting column is also selecting it. Anyway I tried in upper case, where the contence of table is constantly changing (delete all, add a bunch of new records), hence a bunch of errors popped up on 'replace all' command. I guess there is no lock on table when you clic 'replace all' ? I think lock should be done. |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
Yeah ,no lock. Otherwise I would see lock in lower window, right ? |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
On second thought, lock, the moment the 'Search and replace text' window is opened. Unless the errors would be cumulatively popede out in lower window after 'replace all' command ... Without bunch of message boxes. |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
Tested on 'fixed' contence table. I guess this shoul do regex replace only on first column in query result grid, as the first columnns is selected by clicking on column title ? It does not do so, it replacec in complete data grid. 
|
|
Written by ansgar
4 months ago 3966 posts since Fri, 07 Apr 06 |
Well, that's intentionally. Use the column selector to deselect unwanted columns first. |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
There is no column selector on data grid that is result of query. Only on data grid as resut of data tab on table. Point beeeing - I see a big plus of this search & replace & regex thing. It should enable you to do what you can't do in mysql at all, without writing extra program for that. But, as it is wery likely that I would do regex update based on things that I see in other columns, I don't want them to be hidden. Obout LOCK from other posts above, I think the best flow would be: 1.click replace all 2.lock table 3.reselect based on query (as data mybe changed while looking at dialog) 4.do update 5.unlock table |
|
Written by BubikolRamios
4 months ago 273 posts since Thu, 14 Jan 10 |
Mybe general fuctionality of selecting colums in data grid,windows like (MS Excell, OO Calc), CTRL +Click , SHIFT +click should be implemented. You would have then sort funczionality limited to sort icon in column title only. I see many benefits of that. |
|
Written by ansgar
4 months ago 3966 posts since Fri, 07 Apr 06 |
> There is no column selector on data grid that is result of query I meant the data tab, not the query tab. Writing a query, users select columns by the editable query. |
|
Written by Rvanlaak
2 months ago 22 posts since Sat, 25 Dec 10 |
Maybe a "preview changes" function would be nice. No idea how you're managing the change-queries, something with color-highlighting in the grid would be even great. |
|
Please login to leave a reply, or register at first. |