Forum Replies Created
-
AuthorPosts
-
Jan.S
MemberHi,
Please create a ticket by sending an email to [email protected] so that we can help fix your issue.
Regards,
Janani
MemberHi,
We would need your HTTP connection details to debug this issue.
You can send the details in a private support ticket by sending an email to [email protected].
Regards,
Janani
MemberHi,
This is due to an issue in autocomplete where it does not handle insert statements in stored procedures properly. We are working on fixing it right now.
In the meantime, you can go to Tools->Preferences->Power Tools and uncheck the enable autocomplete option. This will enable you to continue working on the stored procedure.
We will let you know once the issue has been fixed.
MemberWe have released 11.11 which should not have this issue. You can read the release notes and download from http://blog.webyog.com/
Member@thrawg: We have a build that works on our test machine where we were able to reproduce this. If you would be willing to test the build, you can create a support ticket by sending an email to [email protected] , and we will give you the link to the test build. Also please let us know which version of SQLyog you are using.
MemberMemberIf there are many tables with a column of the same name, then if we do not explicitly choose a table, any modifications made could be ambiguous.
For example, If there is a table with columns actor_id and actor, and another table with film_name and actor_id, a stored procedure with join on both tables will result in a column actor_id. While updating the column, it could pertain to either the film table or the actor table.
Therefore, the only way to edit a result where multiple tables are involved is by selecting a specific table from the drop down and editing the values in that table.
April 2, 2013 at 12:57 pm in reply to: Problem Running Multiple Sql Statements In The Query Window #34275MemberI don't think you have looked at our screen shots carefully. In your first screenshot, there are 2 result tabs. Could you click on the second one? It should have the result of your second statement.
Please take a look at the attached screenshot.
MemberYou can use LOAD LOCAL to import values from a csv file into your MySQL table if the table structure already exists. The screenshot for the same is attached.
Import external data uses the Microsoft Text ODBC driver, and the driver returns the data as a timestamp, so there isn't anything that can be done from SQLyog to change that.
MemberSQLyog 11.1 Beta1 has been released with this feature.
MemberYes, this change will encode all passwords in all xml job files.
There are still some issues with http://code.google.com/p/sqlyog/issues/detail?id=827. This thread will be updated once Beta1 is released.
MemberHi,
Here are the answers:
1. Create a job file for import
2. Create a job (using SQLyog's Scheduler and Reporting Tool) to execute the required query, or create a trigger to automatically execute the query when data is added.
3. Create a job file for data sync
Q1. The jobs cannot be combined into a single job. However you can write a batch script to run these jobs, and then schedule it, so it will be synchronized.
Q2: You will need to add another job to run a query to get what information you require to add into the other table. This can also be added to the batch script
Q3: With SJA this is the best way to accomplish what you want to do. We don't use or comment on other tools, so we can not tell you if there is a better way to do this using some other tool.
Regards,
Janani
MemberAre you using the 64 bit version or the 32 bit version of SQLyog? Is this behavior seen in both?
MemberWe can extend the preference to include other SQLyog generated statements like in the alter table preview. However we will not be able to do this for statements returned by MySQL, like the create table statement in the Info Tab.
This has been added to our issue tracker here.
March 22, 2013 at 5:18 am in reply to: Database(S) Filter Not Applied In Synchronisation-Dialog Dropdown #34255MemberSchema Sync uses the connections open in SQLyog, so the settings specified in the connection manager are used.
Data Sync creates new connections to each server/database for synchronization, and those connections do not have to be open in SQLyog. Therefore they do not use the settings of the open connections.
-
AuthorPosts
