Forum Replies Created
-
AuthorPosts
-
RiteshMember
In the current version of SQLyog, you can edit an ORDERED set of data by using “Execute For Update (F8)” option.
e.g. execute a query like
Code:select * from tablename order by column descand press F8. It will bring up the Insert/Update window where you can update the data.
RiteshMember“ORDER BY” feature in Insert/Updare window is planned for SQLyog Max. More information about SQLyog Max can be found at http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=472
RiteshMemberThe above bug was present in SQLyog 3.61 as reported by nelson1993
RiteshMemberThis bug was fixed in SQLyog 3.62. I executed the following sql in SQLyog 3.62 & 3.63 –
Code:#this is a comment
alter table `ritesh`.`db` ,change `Db` `Db` int (64) NOT NULL ,drop primary key, add primary key (`Host`, `Db`, `User` );The outputs are given in the attached images. I executed the above statement using F5 and Shift+F5.
SQLyog strips off all the carriage return characters before adding them to the History window. It will send the query to MySQL as entered by the user.
RiteshMemberWhat a coincidence I was just going to mail you 🙂
We tried uploading the data ( around .3 million records ) that you sent us. It worked fine for us. It takes some time to insert .3 million rows. All of this happens in one thread and the GUI is not able to respond to events. This gives an impression that the system is not responding.
RiteshMemberCan you send me a backup of the database (specifically the errorneous table)?
RiteshMemberCan you tell me the version of SQLyog and MySQL?
RiteshMemberAre you using Tools->Structure Synchronization Tool or Tools->Database Synchronization Tool?
RiteshMemberI have received the file. Will revert back soon.
RiteshMemberNope.
Can you send it again? Do a BCC to [email protected].
RiteshMemberActually the app is not hanging. Since the option is running on the main thread it is not able to process any other GUI events.
Can you send me a .zip of the sql file?
RiteshMemberThanks for the feature request 🙂
RiteshMemberHmmmm
Thanks for the feature request 🙂
RiteshMemberSelect the table in the ObjectBrowser and press Enter
RiteshMemberCan you tell me the complete error message?
When are you getting the error message?
-
AuthorPosts