[ashwin]

Hi,

Issues are confirmed. We will fix these and include in our next public release.

Thanks for reporting,

Ashwin A

[ashwin]

Hi,

We have released SQLyog 9.2 beta 1 with 'Clone connection' feature.

Please refer to:

http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

Regards,

Ashwin A

[ashwin]

Hi,

We have released SQLyog 9.2 beta 1 with 'date picker' feature.

Please refer to:

http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

Thanks for your suggestion.

Regards,

Ashwin A

[ashwin]

Hi,

We have released SQLyog 9.2 beta 1 with 'date picker' feature.

Please refer to:

http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

Thanks for your suggestion.

Regards,

Ashwin A

[ashwin]

Hi,

We have released SQLyog 9.2 beta 1 with this fix.

Please refer to:

http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

Thanks for reporting this issue to us.

Regards,

Ashwin A

[ashwin]

Hi,

We have released SQLyog 9.2 beta 1 with this fix.

Please refer to:

http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

Thanks for reporting this issue to us.

Regards,

Ashwin A

[ashwin]

Hi,

Thanks for reporting this to us. We will change ALT+F -> R to Alt+F -> H. This fix will be available in the next public release(probably today).

Thanks,

Ashwin A

[ashwin]

Hi,

We have reproduced the issue and is fixed now. It will be available in the next public release(probably tomorrow). If you need the fix urgently we can provide you a special not-release build to you.

Thanks for reporting,

Ashwin

[ashwin]

Hi,

Quote:

When I tried to reset it I got a message “Invalid default value for 'ID'” which is my index field

Auto-increment column must be indexed, and it cannot have a DEFAULT value. Refer http://dev.mysql.com/doc/refman/5.6/en/create-table.html

If you enable the option “With Indexes” in “Duplicate Table” then the Auto-increment column will be indexed. Please check this option as shown in the attached image.

Thanks,

Ashwin A

[ashwin]

Yes, try to create a stored procedure that starts with a cursor declaration only. You can look into this: http://bugs.mysql.com/bug.php?id=27823

“DECLARE is allowed only inside a BEGIN … END compound statement and must be at its start, before any other statements.”

[ashwin]

Hi,

Now we have an option to change the “Foreground color”. You can download the SQLyog 9.10 GA from here:

http://www.webyog.com/blog/2011/06/09/mysql-data-search-data-at-your-finger-tips/

Thanks for your suggestion.

Thanks,

Ashwin A

[ashwin]

Hi,

The issue has been fixed and you can download the SQLyog 9.10 GA from here:

http://www.webyog.com/blog/2011/06/09/mysql-data-search-data-at-your-finger-tips/

Thanks for reporting this.

Thanks,

Ashwin A

[ashwin]

Hi,

This fix has been made public.

You can download the SQLyog 9.10 GA from here:

http://www.webyog.com/blog/2011/06/09/mysql-data-search-data-at-your-finger-tips/

Thanks for reporting this.

Thanks,

Ashwin A

[ashwin]

Quote:

I was wondering if the default behavior for “Create bulk insert statement” for a dump could be modified to insert values in blocks of 10 or 50, as the old MySql Administrator GUI Tool did. That is, instead of 1 insert statement followed by a giant block of all rows in the table, have 1 insert statement for every 10-50 rows.

There is an option in Tools -> Preferences -> General tab -> under Export option- “Max. size (in K:cool: for BULK INSERT statement(s)”. The DUMP (SQL-file) will contain INSERT statements with the (textual) length as you specify here. The option to 'get server default' will use the 'max_allowed-packet' setting for the actual server. Refer attached image.

NOTE: The size should be specified not larger than the max_allowed_packet setting on the server where you want to restore the dump.

Regards,

Ashwin A

[ashwin]

Hi,

We tried your case at our end. Seems like in your query there are two tabs after SELECT and while pasting, MySQL CLI's auto-complete option gets in the way which interprets the tab as the auto-complete keyboard shortcut. Can you please verify this by turning off the auto-complete feature on start-up with -A (eg: mysql -A -h localhost -u root -P 3306 -p)?

Regards,

Ashwin

[Author]

Posts