Variables In Query Tab, And Save Query Tab Content On Close.

[marcm]

I don't know if this exists yet, but it would be great if we could set variables in the query window. I often paste long queries from my scripts into the window to work on them, and I almost always have to manually replace variables, and then change them back. It would be awesome if I could 'set' a variable ahead of the query itself. Is this possible already?

Also, one of the things that I would LOVE to see is a 'save' query tab 'state' on close and restart of SQLyog. I often have many tabs open over the course of a long work session. I would love to just be able to close SQLyog and know they will remain intact after I restart the application. Firefox does this with tabs and it's invaluable.

So there's some feature requests. Thanks.

[peterlaursen]

1) First request: not possible currently. This is basically a request for some scripting functionality in the editor or a completely new type of TAB (a scripting TA:cool:. I understand that you want the query string with a 'placeholder' like

SELECT $*col1, $*col2 FROM $*table1

Here $* marks are placeholders and values here are substituted with values from a list or a file.  Did I understand? It is not uncommon to do such things on Linux using Perl or Python for instance.  Do you have any idea of a scripting language that could be used on Windows with MySQL a similar way?  Basically we would need to integrate a language-parser.  It should both be very simple to learn and also something standard.  Lua, Python?

2) Second request: we are considering a 'projects' feature so that a 'project' can be opened in one shot.  But you should expect at least ½ year before we start it, I think. It is not planned for next major release (codename “9.X”).

[Author]

Posts