[navyashree.r]

Hi,

Your request has been added in our list,

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

Thank You.

Regards,

Navya

[navyashree.r]

Hi,

Thank you for your interest. We will discuss. 🙂

Regards,

Navya

[navyashree.r]

Hi,

Can you please provide table dump with few rows so that we can reproduce at our end?

Regards,

Navya

[navyashree.r]

chuang wrote on Jul 22 2008, 12:37 AM:

When I do multiple select * queries, the results could be displayed one after one (on one page, one tab), instead of currently it will be divided into two tabs

Hi,

Could you please brief out more in detail regarding results displaying one after one (on one page, one tab)? Is that result should be displayed one below the other in same single tab. Sorry, we could'nt get.

Actaully, we do have the request regarding multi results differentiation. Please read the link below,

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

Regards,

Navya

[navyashree.r]

peterlaursen wrote on Jul 16 2008, 10:32 PM:

At this point it starts complaining that the database in A doesn't exist. If you leave the schema tool, you see that the connections in the main GUI are “confused”.

Hi,

Can you please attach the screenshot of the error message and also can you please brief out about the point why “confused”?

Thanks in advance.

Regards,

Navya

[navyashree.r]

maxhugen wrote on Jul 15 2008, 06:19 AM:

When I first start SQLyog, its reasonably quick with queries, viewing table data etc. But, if I leave SQLyog alone for a while (say, 30 mins), and then come back to check something again, its really slow. It can be some minutes before anything happens. Then more queries will run OK again.

Hi Max,

Can you please detail more?

— Which SQLyog and MySQL version you are using?

— Is it direct, Http or ssh connection?

— And can you explain what is that “checking something again” i.e. are you just clicking on any feature which is becoming slow? Can you provide a test case because here at our end its not reproducible.

Regards,

Navya

[navyashree.r]

Anggriani wrote on Jul 14 2008, 05:10 AM:

I also use SQLyog Enterprise but I don't understand how to use SchemaDesigner…

Hi,

Below arethe steps how to use Schemadesigner,

— First open SchemaDesigner and select database which one you want to work upon.

— Then right click on canvas — Add tables or drag n drop tables on canvas from the selected database or you can move existing tables from the Object Browser into the canvas by double-clicking it

— Here, you can select individual table or all tables to be dropped on canvas.

— Next, when a table is added to the canvas, the table symbol will include a toolbar displaying small icons that let you perform the operations:

Alter Table, Manage Indexes, Manage Foreign Keys, Change the table view to display only the column name or both the column name and the data type

— And also, you can refresh the canvas

— After doing any of the operations, we can save the design in XML file format and then open again to edit.

Refer SQLyog help document for more and detailed information.

Anggriani wrote on Jul 14 2008, 05:10 AM:

the second I have an application that has connected all the tables so all the tables already have the relationship but in SQLyog it is not connected yet… Why?can you give an explanation about it?

2. To see all the relationship between tables, first and foremost, we need to open SchemaDesigner and then drop all tables on to the canvas. Here, you can see if any relationship exist between tables.

But before that can you please brief out from which application you created the relationship?

Regards,

Navya

[navyashree.r]

Stacy Martin wrote on Jul 13 2008, 07:06 PM:

– if a query is currently running, the Keyboard shortcuts do not respond (using the Menu will still works though).

Hi,

Keyboard shortcut issue was already in our list and fixed in 7.0 beta1 and working fine i.e. when large query is executed and need a new connection.

Quote:

– it's not as easy to switch between your multiple queries quickly. Sure I can use Ctrl + TAB to toggle between the connections, but nothing beats the speed and simplicity of opening and using a new query tab.

– it becomes cumbersome to open a new connection if you are using the included SSH tunneling. Since with the SSH tunnel, you must specify a local port to use and the current implementation does not allow other connections to use this same port. You therefore can't open a new connection with the same settings, but must instead use an entirely new connection.

– This is more of a philosophical comment but – I'd be wary that novice users might be intimidated by the complexity such an approach brings, but is necessary in order to do launch a 2nd query while another one is running. You now have a model where you have multiple connections, each which might have multiple previously run queries, and potentially each query with multiple query result sets. Seems like there is the potential for people to get “lost” in the product.

About new query tab when large query is being executed, regarding this we will discuss. Thank you.

Regards,

Navya

[navyashree.r]

Stacy Martin wrote on Jul 13 2008, 07:49 PM:

Is there a keyboard shortcut for closing an Query editor tab? Web Browsers like FF and IE use Ctrl-W to close a tab, as does MySQL query browser. I can't seem to find a keystroke for doing the same in SQLyog.

Hi Martin,

We have added in our list. Thank You for your suggestion,

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

Regards,

Navya

[navyashree.r]

tfg wrote on Jul 11 2008, 02:16 AM:

I selected a table and then clicked on “3 Data Table” tab which displayed the data in the table. I have a text field which is 1024 character. I have been trying to copy/paste a text string that is somewhere around 600 characters in length and every time I do it, it gets cut off (last 40-50 characters or so).

Hi tfg,

This is known bug and already in our list,

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

tfg wrote:

As a side question, how can I find all of the posts I made? I put my username in the search (tfg) but it gives me an error saying the search word was less than 4 letters.

. To find all posts made by you simply click on Members button which is before Search button.

. Then in 'Members name' type your name “tfg”. Enter

. See image “username_search.jpg”, click on member's list.

. Here you get all postings what you made.

Regards,

Navya

[navyashree.r]

Hi,

Issue confirmed and will be fixed with high priority.

Regards,

Navya

[navyashree.r]

Mahesh wrote on Jul 2 2008, 12:21 PM:

There is no way to continue import if any error occurs.

@ Error:Data truncated for column 'training' at row 1

I think the sql dump may contains sql_mode variable value as SQL_MODE ='STRICT_ALL_TABLES'.

Set this value to ,

SET SQL_MODE='' in the SQL dump and try import.

Hi,

And also please go through the link below for more details,

http://dev.mysql.com/tech-resources/articl…-integrity.html

Regards,

Navya

[navyashree.r]

zef wrote on Jun 29 2008, 11:22 AM:

Maybe SQLyog could display wanings automaticaly if any appear as a result of a executed statement.

Hi Zef,

We have added in our feature list. But the priority is not known. Thank you for your request. See the link below,

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

Regards,

Navya

[navyashree.r]

Hi,

“SHOW WARNINGS ;”

SHOW WARNINGS shows warning that resulted from the last executed statement.

Regards,

Navya

[navyashree.r]

Hi,

We followed the same steps what you gave. Here its working fine as soon as we clicked on Ctrl + O after disabling network we got an error message. Please do see the screenshot attached below.

Regards,

Navya

[Author]

Posts