[navyashree.r]

See image 'network_gone.jpg'

[navyashree.r]

DonQuichote wrote on Jun 20 2008, 02:28 PM:

2. It is nice to see more types of queries on the right click of a table (PASTE Delete …). However, they do not get pasted in the query window. Instead, a right-click menu is activated on the query window.

3. When I tried a right-click on a table and selected TRUNCATE, an extra right-click menu appeared on the structure window, the confirmation box was shown and my entire desktop froze. I had to kill any wine-related process through a terminal.

Hi,

Issue confirmed. See below google code for issues 2nd and 3rd,

http://code.google.com/p/sqlyog/issues/detail?id=744

And also for time being you can use keyboard Menu.

Quote:

1. switching between open connections and their windows does not work: If I connect to a database server, the corresponding window is opened maximized. If I open another connection, it is opened maximize and on top of the first. There is no way to switch between them. That is, the Window menu offers 2 entries, but there is no reaction if I choose the other window.

Here, switching between connections can be done in 2 ways i.e. by pressing Ctrl+tab or just open Windows menu and open which connection you want. Here it is working fine on Ubuntu 7.04

Quote:

Also, the standard window box buttons on the upper right of the “document” window (minimize, close, unmaximize) do not work.

Can you please elaborate regarding this issue?

Thank you for your interest and waiting for reply.

Regards,

Navya

[navyashree.r]

navyashree.r wrote on May 15 2008, 06:15 AM:

Hi Davis,

When we click Tab while typing MySQL keywords displays in caps in query editor. So, can you please tell that when we type MySQL words in small and click “SPACE” it should automatically take in caps. Is this what you meant?

Example,

select –> “Space” –> SELECT

Thank You.

Regards,

Navya

Hi,

Added in our list,

http://code.google.com/p/sqlyog/issues/detail?id=718

Navya

[navyashree.r]

rvps wrote on May 15 2008, 04:01 AM:

just saw this myself after updating to the latest version today.

YEAH BABY!!!! WOO HOO!!!!

(I was about to call red gate and see if they offered a plugin for mysql. 😛

Kudos on this.

While we are on the subject… How about auto capitalization of MySQL reserved words (SELECT, FROM, WHERE, ON, AS, MYSQL FUNCTONS, ETC…) 😀

Hi Davis,

When we click Tab while typing MySQL keywords displays in caps in query editor. So, can you please tell that when we type MySQL words in small and click “SPACE” it should automatically take in caps. Is this what you meant?

Example,

select –> “Space” –> SELECT

Thank You.

Regards,

Navya

[navyashree.r]

Hi,

Here, while starting SQLyog it's not flickering. So, can you please tell the test case when it is flickering exactly at what instantce??

Regards,

Navya

[navyashree.r]

jd wuz here wrote on May 1 2008, 10:51 AM:

When i browse the F9 result window and that window is focused i cat reexecute the query by pressing F9 again, but if i try to do that with F8 results reexecute will not work until i focus the query window. I understand that someone might press F8 while editing some data, but i see no reason for disabling the F8 when nothing yet was edited in the results.

Hi,

In Tools >> Preferences >> Keep focus on SQL editor after query execution should be checked. So, if this option is checked and when u press F9/F8 as many times the focus remains in the same place.

Regards,

Navya

[navyashree.r]

Hi,

There is some incompatibility in Vista and XP for the window type we used for connection window. We made fix to solve right border artefact issue in Vista which has reverse effect in XP. So, these 2 issues are reproducible and we are finding permanent solution. These 2 issues are added in our list.

http://code.google.com/p/sqlyog/issues/detail?id=698

Regards,

Navya

[navyashree.r]

jaabe wrote on Apr 29 2008, 05:40 AM:

Thank you for replying. What I really want to know is the implementation of History. Is this an SQL command to retrieve the SQL history, if so, which command ? If I understand how History is implemented then I can adjust my schema so part or all is hidden

Hi,

1. There is no JDBC (or PHP or PERL or whatver) involved. SQLyog is a C++ program and does any other connector then the C-API itself.

2. Also there is no SQL involved. HISTORY is log which is not retrieved from the server (and also it is not a server log too). It records every statement (with a few exceptions) sent from the actual SQLyog connection ONLY.

3. We have no plans to provide an option to make HISTORY 'invisible' or filter it.

4. To hide information stored in the database from the user that is using SQLyog, the correct way in MySQL is to manage privileges on the server and connect as a user with appropriate privileges only.

Thank You.

Regards,

Navya

[navyashree.r]

jaabe wrote on Apr 29 2008, 03:29 AM:

Hi

I was wondering how statement history works. Is this a system SQL statement or just a JDBC method. If I don't want history of SQL statements to appear or only for certain users i may want to have some restrictions

Hi Jaabe,

History tab heps you to get all queries you executed except for the threads used(like Copy db, Export db, SJA) which doesnot displays in history.

Regarding Show/Hide History tab option we need to discuss.

Regards,

Navya

[navyashree.r]

Hi,

This has been added to our list. Thank You.

Regards,

Navya

[navyashree.r]

uyuni wrote on Apr 22 2008, 06:52 PM:

That's why I like this tool! User suggestions and error fixes are integrated quickly! :-))

Hi,

With Pleasure. Thank you for your interest……………. 🙂

Regards,

Navya

[navyashree.r]

Bruce Leister wrote on Apr 22 2008, 12:52 AM:

I also find it slightly annoying that I have to click on the Database in the Object Browser, and a again on tables to get a list of the tables in the Database.

I agree that there could be situations where it is not desirable to open the Tables tree (to list the tables), so perhaps we could have an option in Preferences to:

Auto-Open Tables tree when database is first selected (expended)

Bruce Leister

Hi,

Your request has been added to our list,

http://code.google.com/p/sqlyog/issues/detail?id=680

Thank You.

Regards,

Navya

[navyashree.r]

tlen wrote on Apr 21 2008, 07:19 PM:

Hi,

i think it would be great to have the .gz support in restoring DBs made with sqldump + Gzip.

Yes, obviusly the .gz can be decompressed manually, but in a situation where there are scheduled backups made remotely with sqldump+Gzip, it would be great to just import seamlessy these gzipped dump. not tar+gzip, only gzip, something like backup.sql.gz

Thanks

Hi,

We added this in our list but it is not priority, http://code.google.com/p/sqlyog/issues/detail?id=422.

Also more likely that we will support Windows ZIP than any UNIX compressed format.

Regards,

Navya

[navyashree.r]

Hi Susa,

If you really want to store all these zeros in the column I suggest you pad them upon insert. Otherwise you can pad them upon selecting. SQL Server does not have an automatic fill feature like this but you can do this very easily with code similar to this:

SELECT concat(“000”,num) as account;

Also,

SELECT LPAD(str,len,padstr);

Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.

Example:

SELECT LPAD('000',6,'111');

susa wrote on Apr 10 2008, 05:05 PM:

concat(num1, num2) as account

assuming that num1 = 123 and num2 = 999, then account = 123999

no problem with above

if num = 000 then account becomes 999 and I want 000999

ie. concat(zerofill(num1), num2) as account

what is the correct method?

this works

concat(lpad(num1,3,0), num2) as account

[navyashree.r]

Keith Davis wrote on Apr 10 2008, 04:10 PM:

I have always been disappointed that SQLyog did not provide field drop downs for aliased tables, as I always alias. I am sooooooo excited that the new version fixes/adds this feature that I just had to say……

THANKS!!!!!

Hi Davis,

With pleasure. Thank you for your interest ………. 🙂

Regards,

Navya

[Author]

Posts