[Ritesh]

This feature will be implemented in SQLyog 4.1.

[Ritesh]

You can edit result returned by a query using Edit->Execute Query->Execute For Update… or by pressing F8 instead of F5. A Grid will come up with the result which you can update. This allows you to edit a Resultset having a complex WHERE clause or JOINS. SQLyog will generate the corresponding Insert/Update script to commit the changes.

I guess this is what you are looking for.

[Ritesh]

Go to Tools->Preferences… and uncheck the option Truncate Column Headers To Max Data Size.

This will solve your problem.

[Ritesh]

BTW, what is the SQLyog folder for? We dont create any folder by the name of SQLyog. Only Personal folder gets created by the installer.

[Ritesh]

The screenshot looks good.

Which version of MySQL are you using?

At our end we are testing SQLyog with MySQL versions – 3.23.54, 4.0.18, 4.1.5, 4.1.7 and 5.0 without any problem. Is it possible to get temporary access to the MySQL server? We can try connecting from our end and fix the bug (if there are any).

The bug has not been fixed yet because nobody reported similar issue before this 🙁

[Ritesh]

I have replied to your mail.

[Ritesh]

This is strange.

Can you check and tell me the files that are present in the SQLyog installation directory? A screenshot of the folder will be best.

Which OS are you using?

Information about the connection type you are using will also be helpful.

[Ritesh]

This is a known bug in SJA 2.0 and has been fixed in SJA 4.0.

The Linux version of SJA 4.0 is not yet 4.1.7 compatible. We will be coming out with a new release soon.

I will keep you updated in this thread.

[Ritesh]

This feature is planned for SQLyog 4.1.

[Ritesh]

Quote:

— a “click” sort of the columns while in edit mode

— the ability to oggle the visibility of columns displayed.

These options are planned for SQLyog Max.

Quote:

Dragging and dropping tables from one database to another is pretty handy feature. Itr seesm that we're often building test databases to try something on. I like the ability of dragging the tables I want to a new database.

The above feature is also planned for SQLyog Max.

Quote:

The Navicat filtering of displayed data is pretty cool. SQLyog's quick filters are neat, but I like the ability to build a complex where clause with the Navicat filters. Mind you I find that as I get better at just typing what I want I am quicker in SQLyog. Now that I know about the F8 key SQLyog is working pretty well for me.

What you want to do is currently available using F8 option. I guess you want a GUI to do the same. Am I correct?

[Ritesh]

Are you sure you are using SQLyog's Database Sync Tool (SJA)? SJA does not generate SQL script. Looking at the sample it seems you are using SQLyog's Export As Batch Script… option.

Assuming that you are using Export As Batch Script… option, the error can occur if the target server is running an old version of MySQL. Can you tell me the MySQL version running in your target server?

[Ritesh]

Quote:

1) Ability to edit the result set returned from a query.

You require Edit->Execute Query->Execute for Update…. or you just need to execute the query by pressing F8 instead of F5.

Quote:

Export features are weak and don't save the previously used options making it annoying to use.

Which area do you think SQLyog is weak? Can you tell me the options where SQLyog does not save previously used options? Maybe you are missing something. If its a bug, I assure you that it will fixed within a week.

Quote:

I can't seem to figure out how to set the display character set. Actually there are almost no preferences to set in the product

This feature is planned for SQLyog Max.

Quote:

I guess Navicat, despite it's slowness and quirks. is still the best tool for me.

I would love to know the features that you like in Navicat and is not present in SQLyog.

BTW, have you tried SQLyog 4.0 BETA. It has lot of improvements and bug-fixes. For more information visit: http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=977

[Ritesh]

No.

Currently, SQLyog supports only MySQL database.

[Ritesh]

Since, SQLyog uses LOAD LOCAL… syntax to import data from a text file, the following link might be helpful:

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html

[Ritesh]

If you are looking for a FTP client then you might consider CuteFTP.

[Author]

Posts