[DAE51D]

Awesome. I will start to compile a list!

[DAE51D]

Add my name to the list of people who HATE this new UI.

Why did you move “Table Data” up to the top too? It's useless as you can't click the tab, then write a SQL query in the editor viewing the data! You have to actually do your first query as “SELECT * FROM `foo` LIMIT 0, 2500;” JUST so that it shows data in the bottom half under “Result”. WTF?

You should make the tabs dragable into either top or bottom (and remember preference).

Also, come on guys, seriously we still can't rename the Query editor tabs??! A 'right click menu' that only has 'close' in it?!

While I'm at it, the “Preference” menu has been pretty sparse forever. When are we going to get more customizable features. For one thing I *hate* that when I choose: “Paste SQL statements” it stacks the columns like I have in my preferences for F12. If I'm having you generate me a SQL statement, you can pretty much bet your ass I need it to paste into my PHP code and preferably as a single line. HOWEVER when I'm debugging a SQL statement, THAT is when I want to F12 it and make it readable. Two different use cases. And that's just one example of probably 20 more that I could think of for preference settings. Another annoyance is that I always set my “default rows” to 5000, yet it always seems to be set to 25!? WHY!? ugh.

Toad is starting to look more and more appealing. We're on version 10 now of SQLYog and it doesn't do half of the features Toad 6 does. AND Toad is free! I use SQLYog because I've used it for many years and it's comfortable. It's like second nature, but when you start to make changes that detract from my productivity, well, then I might as well switch to another tool if I have to re-train the way I work. Just sayin'. And I promise you I'm not waiting “two months” for a fix for something you guys broke that is so integral to work flow. I'm already reverting to 9, and give it two weeks tops before I bail on SQLYog all together.

[DAE51D]

Seriously, this has been requested for OVER FIVE YEARS (Sep 10, 200) and in SQLYog 9.30 I still can not rename the Query tabs. *sigh* 😮

[DAE51D]

I just noticed you have a “(o) Form (o) Grid” radio buttons, which is partially what the G does.

I guess I'm asking that you recognized “G” just as you do the “;” so that it's parsed automatically and displays the results in form mode accordingly.

Also, CTRL+L does NOT give you a text version of the Form view as it does for Grid view, so I can copy/paste it into emails, etc.

[DAE51D]

I was just logging in now to suggest this exact same feature. I thought that if I clicked “Save” it would prompt me for a name and I was hoping that if I changed the name it would save as a new one, or if I left it, it would over-write the existing one. Sadly there was no prompt at all and it just saved in place. So yeah, add my +1 vote for this.

[DAE51D]

here's another one that doesn't format…

Code:

select
sla_flight.id_operator,
sla_flight.id_aircraft,
sla_flight.id_sla_flight,
ifnull(dim_seat.id_dim_seat, 1) as id_dim_seat,
case when dim_seat.id_dim_seat is null then 1 when dim_seat.id_dim_seat = 1 then 1 when dim_seat.id_dim_seat <= 105 then 3 else 4 end as id_dim_seat_class,
fmr.id_fmr,
sla_flight_has_fmr.deferred
from sla_flight_has_fmr
join sla_flight on sla_flight.id_sla_flight = sla_flight_has_fmr.id_sla_flight
join fmr on fmr.id_fmr = sla_flight_has_fmr.id_fmr
left join fmr_has_seat on fmr_has_seat.id_fmr = fmr.id_fmr
left join dim_seat on dim_seat.id_dim_seat = fmr_has_seat.id_dim_seat
where (fmr.id_sla_function is not null and fmr.seat_count is not null)

This is kind of ridiculous that something as simple as formatting a string of text is such a challenge for SQLyog Ultimate 8.63…

[DAE51D]

Okay this doesn't seem right. If you can format a SQL statement, why can't you format a VIEW?

I have this one and I paste it into the query editor window, hit F12 and NOTHING happens. 🙁 but it does say there is a formatting error.

It doesn't make sense that you blame mySQL for the lack of VIEW formatting? If this is the case, then you need to make your OWN string parser and formatter.

I'm using SQLYog 8.63 Ultimate. I also wish to point out that this bug was opened in 2007 == 3 years ago. Surely this can/should be fixed by now.

[DAE51D]

I have this query that won't format in SQLYog Ultimate 8.5.5

SELECT operator.operator_name, registration.registration_name, archive.id_archive, archive.pipe_name, archive.file_size, FROM_UNIXTIME(load_event.start_time, '%Y-%m-%d') AS data_load_date, load_event.result_code, IF(load_event.result_code = 0, 'PASS', 'FAIL') AS result, load_event.result_string FROM agis_core.archive JOIN load_event ON archive.id_load_event = load_event.id_load_event AND archive.id_operator = 276 AND load_event.result_code <> 0 AND load_event.result_string = '%fdmt%' AND load_event.start_time BETWEEN 1270598400 AND 1281139199 AND archive.pipe_name IN('uploader', 'sita', 'arinc', 'cellmodem') JOIN operator ON archive.id_operator = operator.id_operator JOIN registration ON archive.id_aircraft = registration.id_aircraft ORDER BY data_load_date DESC LIMIT 1000;

[DAE51D]

Well, first of all, if speed is an issue, then make it an option/preference. I'd rather trade a few microseconds of speed for this convenience. Basically it's just a “DESCRIBE TABLE” on each table to get the number of columns. Seems pretty simple and cheap to me. Especially on a development database which is usually local or a VM or on a high-speed LAN.

Another acceptable solution is to populate the (#) part once a table's [+] has been expanded. As soon as I expand the “Tables” [+] then you know I have x tables, so have your code go back and populate the top “Tables (x)” title element — surely you can do this trivially. Same logic for any table I expand. Once I expand it, then you have a free count of how many columns.

Not only would it add the feature, but it also gives a free “clue” of which tables I've expanded already and which ones I'm probably using. As I expand and collapse the tree nodes, it's easier to jump and expand tables I've already opened since they'd be all the ones with a (x) next to their names. I'd say like 80% or more of your DB work is within like 3 or 4 tables, not your entire database. Easy to scan with the eye, especially if you were to color code it maybe in a shade of gray or the blue like the icon next to the name.

You could be really nice and maybe add a Right+CLICK menu item to “expand all” and “collapse all” — and this would accomplish the original feature requested if you implemented it as described here, because then by that one simple action, I get a tally of all the tables.

I think this solution proposed solves all problems.

[DAE51D]

I tried to do repro steps and I can't get it to be consistent. It's almost a race condition I think. My tables are very large, as are the databases. 157 tables in the DB. I'm also using SSH tunnels to connect from my XP box to the DEV/TEST/PROD master/slave pairs.

I'll keep trying to figure out what causes it.

I thought it might be the rebuilding tags, so I deleted them from C:Documents and SettingsvincentdApplication DataSQLyogTags but that doesn't seem to make it happen.

[DAE51D]

+1 to this idea. I often have a need to modify several servers with the same INSERT rows.

[DAE51D]

'smine' wrote on '24:

in SQLyog 8.5 GA Ultimate, when there is only one connection tab, its X close box is inactive. perhaps that is by design, but i would have expected it to close the connection as it does when there are multiple connection tabs.

+1

I noticed this too. I could see it being “by design”, but I'd prefer if I didn't have to open another connection, just to close this one. I have several servers I connect to and sometimes when my head isn't on right, I choose the wrong one when I start up SQLYog and would like to go, “oops, let me close that and get the right one”. as it stands, I have to go, “Ooops, let me load the right one and remember to switch tabs and close the wrong one before I accidentally execute my query in the wrong window”.

[DAE51D]

'peterlaursen' wrote on '17:

It is not possible to read from the .ini where the program shall find the .ini.  That is how I understand you.  Would you put the code to your bank box into the bank box itself?  It has to be a command switch.

Correct me if I misunderstand you.

Please see the top post. This is pretty straight forward. You would pass the .ini file as a parameter on the command line just as you do any other parameter. This would then let you have many .ini files in the same default SQLYog directory as when installed.

The “hack” solution suggested by you guys is to use a NEW DIRECTORY. This is overkill. I just want a new .ini file as that has ALL the useful information in it for connections.

[DAE51D]

'peterlaursen' wrote on '09:

The problem with 'export to clipboard is in my understanding that there is no safe way to ensure that Windows will not truncate. Nobody knows in advance how big the clipboard is. It depends on what else is running. (but maybe I am wrong here?)

I wouldn't worry about the buffer size. I think in most (if not ALL use cases), we're talking about very small amounts of data — hence the reason it's irritating to have to export to a file, then load it back in, just to get a “quick” SQL dump.

As mentioned, I often need to just blast in a few records and once I have inserted one via the GUI, I want a quick and easy way of “duplicating” that record with some minor changes. Say I am creating a user table to test my new super amazing world changing social network, well then I need more than 1 user to test with, so I'll take user.id == 1 (me usually) and clone my “INSERT INTO users (id, name, gender) VALUES (1, 'daevid', 'm')” statement and tweak the second “(…)” part to make user (null, 'joe', 'm'), (null, 'bob', 'm'), (null, 'mary', 'f') etc… so I have some data to play with. Exporting a file for a schema or data for a single row is overkill.

But a quick Google search reveals this: http://www.techtalkz.com/windows-xp/423447-clipboard-limit.html

Quote:

The amount of data a that can be placed on the clipboard depends on the amount of free memory available. Programs running shares the available memory with the clipboard. Less programs running the more data that you can store on the clipboard. To see the contents of your clipboard: Start > Run > type clipbrd.

So your concern is moot. 🙄

[DAE51D]

'peterlaursen' wrote on '09:

You can start SQLyog with a 'dir' switch (edit 'properties' of the desktop/start menu icon from the context menu).

Refer: http://www.webyog.com/blog/2009/08/14/sqlyog-813-has-been-released/

Interesting. I did not know that. However this means I have to have a separate directory setup. I supposed that is a short term solution. But the “sqlyog.ini” file contains all the directory paths and such, so I'd have to have a directory JUST to have a file named “sqlyog.ini” in it. Since you already have this “logic” why not put a 'config' or 'ini' switch like you have 'dir' and that switch takes on the path and filename of an alternate .ini file.

This might seem nit-picky, but I think it makes more sense to have an .ini file that sets up the directories and such than it is to have a directory parameter which is then redundantly using the .ini within the directory to setup the directory. Does that make sense?

[Author]

Posts