sqlyog

Rearrange column order in Sqlyog

Is it possible to rearrange a table's column order in SQL yog? ...

Is .sql file different for MySQL and SQL?

I have a .sql file and I want to load it into MySQL database. I don't know from which database (MySQL or MS-SQL) it was created. Now, I am trying to import that file into MySQL database. It is showing errors while importing and executing that file. Q1. So, my question is whether the .sql file generated from MySQL and MS-SQL are diff...

"please select equal number of source and reference" on sqlyog

I am trying to add a foreign key constraint via sqlyog, and getting this error, although I am only select one source and one reference columns please select equal number of source and reference Does anyone knows what it means in this case? Note that I do have an equal number of source and reference columns... ...

SQLyog question

I'm using SQLyog and I used to Database Synchronization Wizard to make a job (which I saved, and it saved it as an xml file). However, the job doesn't show up in the Job Manager. How do I make this happen? ...

MySQL automatically appending LIMIT 0, 1000 to all queries

SQLyog automatically appending LIMIT 0, 1000 to all queries in a database which is causing the below query (select next_hi from hibernate_unique_key for update) to fail. Query : select next_hi from hibernate_unique_key for update **LIMIT 0, 1000** Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds...

mysql export loses AutoIncrement

When I export a table through SQLYog, the CREATE statement in the exported file lacks AutoIncrement on its primary key, even though the original table contained AutoIncrement. Is this a bug (in Yog or in mysql?)? Should I report it? How can I export the table with the AutoIncrement in place? ...