[Sibin A S]

Hi,

 

We have added this feature you requested in the SQLyog 12.2.2 release. Please refer the blog post for more details, which can be found here >> http://blog.webyog.com/2016/05/05/sqlyog-mysql-gui-12-2-2-released/

 

Regards,

Sibin

[Sibin A S]

Hi,

 

“The host in my case is the same but it’s a different connection to a database with a different name and with a different username.”

 

Based on your inputs, consider the case having two connections i.e, ‘Connection A’ and ‘Connection B’ to the same host, when an object is created in ‘Connection A’, it also gets reflected in ‘Connection B’. So while copying the object, it would return that the object already exists.

 

Can you please clarify this and also give us the test case where we can reproduce it and please elaborate more. Also please tell us the Privileges for both the connections.

[Sibin A S]

Hi,

 

We have added this request into our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2106

 

Regards,

Sibin

[Sibin A S]

Hello Mitch,

 

The error you get is because just having the SELECT privilege on the view/tables should not be enough to view the data. Please grant the ’SHOW VIEW’ privilege on the view inorder to view the data from the View which would rule out the error you get.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

We have added this request to our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2105

 

Regards,

Sibin

[Sibin A S]

Hello Mitch,

 

We did try your query and the autocomplete did work perfectly at our side. Can you please tell us the particular point where the autocomplete does not work in the query if any? so that we could try to reproduce it.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

We have added this request to our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2105 

 

Regards,

Sibin

[Sibin A S]

Hello Mitch,

 

You can use the “Text View” mode(or use the shortcut “Ctrl+L”) in the result/table data tab to select the required data. But SQLyog is a database client and not a spreadsheet. You can do select the required data from Excel as well. 

[Sibin A S]

Hi,

 

SQLyog is a MySQL Client tool used to manage your databases. Just double click on the installer file to install SQLyog and once installation is finished, open SQLyog to enter the MySQL Host Address, User Name, Password and Port in the connection manager to connect to your respective server.

Please refer our doc on how to get started with SQLyog, here >> http://sqlyogkb.webyog.com/category/149-getting-started

Also, we do have online documentation here >> http://sqlyogkb.webyog.com/

 

Regards,

Sibin

[Sibin A S]

Hi George,

 

We have replied in the ticket that was created by you.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

Thanks for your valuable feedback. We have added your request into our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2057

 

Regards,

Sibin

[Sibin A S]

Hi,

 

The value inserted into the table is being returned by your ODBC driver. The number data-type in Excel is SQL_DOUBLE for ODBC Driver. Please refer >> https://msdn.microso…0(v=vs.85).aspx

 

You can also select the corresponding cell from the excel sheet and right click to select the option  >> Format Cells -> Number – > Text. Doing this will ensure that the cell is treated as a text even if a number is present. Therefore letting us display the text to be displayed exactly as entered.

Please refer >>   https://support.micr…en-us/kb/141284

 

Regards,

Sibin

[Sibin A S]

Hi George,

 

Please try giving the entire file path to which the backup file has to be generated in the respective field in the “How do you want to generate the script” dialog window under the “Scheduled Backups” option. 

 

You can also choose from the option to either overwrite the already existing file or append to the existing file.

 

Regards,

Sibin

[Sibin A S]

Hello Mitch,

 

Setting the a query tab linked to a particular database would be infeasible because there can be query tabs that can contain queries related to various databases. It is also a possible test-case where a single SELECT statement can use various databases to fetch the data.

 

Linking a tab to a particular tab is not possible as a tab can contain queries that would use several databases in other scenarios.

 

You can use the “USE” statement to specify the database, therefore letting you to just execute the statements without having to explicitly specify the database for every statements.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

Please write an email at [email protected] regarding this and your request will be processed as soon as possible.

 

Regards,

Sibin

[Author]

Posts