Forum Replies Created
-
AuthorPosts
-
Jan.SMember
Using backquotes is the safe way to generate a MySQL query. What purpose would not having backquotes around object names serve?
Jan.SMember@jjscot:
We have discussed this and decided to add it in the next version of SQLyog – probably version 11.1.
Jan.SMemberSorry, discard my previous reply. I did not read that you were updating from the results window.
While updating from the results window, only fields from a table which are present in the result set, are used for updating.
Lets say you have a table with primary key 'id' and another field 'data'.
If your result set has only 'data' in it, then it will update the table with the query
UPDATE table SET field = value2 WHERE field = value1
as other fields in the table are not available.
If the table's primary key is part of the result set, then it will use the primary key in the where clause.
Jan.SMemberHi Mick,
Wishing you a very happy new year!
We are unable to understand what the problem is. Could you explain what you expect as against what you are getting?
From what we can see, the output seems to be fine.
Also, when you say stale data, do you mean the output in result tab or the statements in history?
Regards,
Janani
Jan.SMemberWe are unable to reproduce this at our end. However, in the past we had one user with the same issue and it was related to Webroot SecureAnywhere AV.
Could you create a support ticket by sending us an email to [email protected] so that we can investigate this issue further.
Regards,
Janani
December 10, 2012 at 10:38 am in reply to: "table Diagnostics" Uses The Wrong Tables In A Specific Case #34033Jan.SMemberIssue confirmed.
Thank you for reporting this issue. We have added it to our issue tracker here and it will be fixed according to priority.
Regards,
Janani
Jan.SMemberHi,
Like I mentioned, whenever a where clause is used, we do not delete any data irrespective of if the “delete extra rows in target” is checked or not. However, we are releasing 10.5 GA within a week, which includes a visual data comparison tool which can be used to delete the extra rows. The beta version with this feature has been released. You can take a look at it and download from here.
Regards,
Janani
Jan.SMemberHowever, extra rows will not be deleted under any circumstance when a WHERE clause is used.
December 6, 2012 at 9:00 am in reply to: Data Sync Not Deleting Row In Target When A Where Clause Added #34010Jan.SMemberHi,
This is by design. When you have a WHERE clause, and rows need to be deleted in the target, there is a discrepancy in which rows should be deleted. Therefore, to avoid any confusion, rows are not deleted when a WHERE clause is used.
Regards,
Janani
Jan.SMember'bitseeker' wrote:But i guess it would be more convenient to have a checkbox on top left
This will be available in the next public release (v 10.0).
Also, you will be able to select individual rows using Ctrl + Spacebar.
Regards,
Janani
Jan.SMemberHi,
We have released 9.61 with this fix – http://www.webyog.com/blog/2012/02/24/sqlyog-9-61-released-now-with-option-for-chinese-interface/
You can take it from here.
Regards,
Janani
February 24, 2012 at 2:49 pm in reply to: Sqlyog Craches When Press Esc In New Table/edit Table View #33167Jan.SMemberHi Nicolae,
We have released 9.61 with this fix.
http://www.webyog.com/blog/2012/02/24/sqlyog-9-61-released-now-with-option-for-chinese-interface/
You can take it from here.
Regards,
Janani
Jan.SMemberCould you take a screenshot of your connection details – both the MySQL tab and the HTTP tabs, and send it to us?
It would be better if you create a support ticket (by sending an email to [email protected]) so that the information provided by you is not publicly viewable.
It could be that your host name isn't correct, or there is some error in the other details, so we would like to check that.
Also, can you connect to the tunnelling url (http:///SQLyogTunnel.php) from your browser? Please take a screenshot and attach it here.
Jan.SMemberHi,
We understand that you are frustrated with the new UI. It will take some time to get used to it.
However, have added this to our issue tracking system here – http://code.google.com/p/sqlyog/issues/detail?id=1752 and will take it up post 10 (approx in 2 months).
Regards,
Janani
Jan.SMemberHi Mitch,
This is not a wine or an Ubuntu issue. We have fixed the column size to prevent the horizontal scrollbar from appearing on opening the tab, in all resolutions.
We will discuss this and get back to you.
Regards,
Janani
-
AuthorPosts