[ashwin]

I have added this issue in our issue tracker: http://code.google.com/p/sqlyog/issues/detail?id=1641

We will fix this and include in the next public release. Thanks for reporting.

Regards,

Ashwin A

[ashwin]

Hi,

We will discuss with the team and update here. Thanks for your suggestion.

[ashwin]

Quote:

so when clicking the + tab have to two current menu items, but also a list of recent, or tags connections to allow a quick way to connect to a new MySQL server.

Do you mean that when you click on “+” it should also list a few recently opened connections? Could you also please explain what tags connection means?

Quote:

Also could you have a optional default database for each connection, I know the first named is defaulted when a named list of databases is listed, but if all is required, nice to have one pre-selected.

An option in Connection Manager called “Default Database” and when you enter a database name there, on connecting to that connection that particular database is highlighted?.

[ashwin]

Hi,

We have added this in our issue tracker: http://code.google.com/p/sqlyog/issues/detail?id=1639

We will be implementing this once our developers complete the features they are implementing currently. Thank you for your suggestion.

[ashwin]

Hi,

We have fixed this. Now you can find the update information. Thanks for reporting.

[ashwin]

Hi,

We have fixed this issue.

You can download the special (not-release) SQLyog build from here:

http://www.webyog.com/downloads/betas/not_released/SQLyog-9.0.2-1.exe

Please try this special build in your environment and let us know the status.

Thanks,

Ashwin A

[ashwin]

Issue confirmed and added in our tracker,

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

We have started to look into this Issue and we will update the status later.

[ashwin]

Hi Mike Harris,

There is 'Print' option in Schema Designer->Canvas context menu. You can take a paper copy of the schema by clicking on the 'Print' option. Refer the attached image.

Thanks,

Ashwin A

[ashwin]

Hi,

We will consider your request and discuss with team and update here.

Thanks for your suggestion.

[ashwin]

Quote:

(`db_logicold_ops`., CONSTRAINT `FK_tbl_batch_manifestProduct` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`))

This error means that there is data in the child table that is not present in the parent table and hence while trying to create a foreign key constraint between the two tables you are getting the above error.

Please ensure that the column that you are trying to create the foreign key on has same data in both the child and the parent table and then try creating a constraint.

[ashwin]

Hi,

Quote:

BUT, in order to get the context menu it seems as if the table contents are downloaded first

I think the table contents are downloaded because the focus was on the “Table Data” tab. You can change the focus to any other Result window- Message tab or History tab.

And additionally you can view the table schema with just a mouse click in the Info tab.

[ashwin]

Hi Mitch,

Issue confirmed. When using “Insert/Update Blob Field” editor if you navigate to another application using ALT+TAB and then come back to SQLyog, the entire text is selected and the cursor position scrolls back to the top. We will look for a possible fix. It is added here: http://code.google.com/p/sqlyog/issues/detail?id=1559

Thanks for reporting this issue.

[ashwin]

Hi,

Quote:

when you e.g. optimize a table through “Tools > Table Diagnostics” the executed statements are not shown in the history tab

Executed statements are shown in the History tab. Can you tell us your SQLyog version?. What exact steps did you perform in “Tools > Table Diagnostics”? And also, clear History tab and perform “Tools > Table Diagnostics” and goto History tab and copy paste the query generated here.

[ashwin]

Hi,

We have released SQLyog 9.0 beta1 with this feature.

Please refer to:

http://www.webyog.com/blog/2011/03/14/sqlyog-mysql-gui-9-0-beta-1-released/

Thanks for your suggestion.

Regards,

Ashwin A

[ashwin]

Hi,

Quote:

Using the alter table dialog to add an enum value that includes a single quote causes an SQL error. It needs to double up the embedded single quote.

Actually, You don't have to add single quote to a value for Enum as SQLyog itself adds single quote for a value. You can just enter a value for Enum without single quote in Create/Alter table.

Thanks and Regards,

Ashiwn A

[Author]

Posts