Copy / Export functionality like in DbVisualizer

[expired user #5242]'s profile image [expired user #5242] posted 9 years ago in Feature discussion Permalink
I'm still using DbVisualizer for some database work - but I would love to switch to HeidiSQL because I mostly use mySQL/MariaDB.

There are two features that I really miss:

"Copy selection as formated text":

tracker_id tracker_ship tracker_datetime tracker_sha1
---------- ------------ ------------------- ----------------------------------------
11840 nordlys 2015-08-15 04:42:01 000a8fd9246b931d0a75e51a2ce925d470a514f0
8326 nordlys 2015-08-12 17:58:01 00d4e9ff571a384e37c518543025897fb3ded903
2843 nordlys 2015-08-08 22:28:01 010e40dd4c0dcee98fa2a3ca6607a3c3984e01ab
1602 nordlys 2015-08-08 08:18:01 011e1d2451ce2ad1fd45f9afe934b384f244c4ae

This gives a simple plain text formated dump of rows/columns/fields selected in the grid view.

"Copy selection as IN clause":

Selecting the first three fields in tracker_sha1 column would give this:

tracker_sha1 IN ('000a8fd9246b931d0a75e51a2ce925d470a514f0','00d4e9ff571a384e37c518543025897fb3ded903','010e40dd4c0dcee98fa2a3ca6607a3c3984e01ab')

Duplicate entries are filtered automatically.

Is it possible to have this nice features in HeidiSQL or is it already there?

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