New answers tagged mysql-5.5
0
Where does id come from in the HAVING? Please qualify it.
The HAVING maybe should be WHERE? Or ON?
Some of these composite indexes may help:
assignment: INDEX(Project_ID, assgin_name)
hub_coordinator: INDEX(Employee_ID, Assign_ID)
hub_coordinator: INDEX(Assign_ID, Employee_ID)
0
If you want to let the database decide which Engine to use, just remove ENGINE=MyISAM from the dump.
0
You can use this portable version of workbench 5.2.47 CE for connections to MySQL server 5.xx and the installed version 8 for newer versions of MySQL Server.
Although I use this software with no problems until now, this is not from my authorship, use it at your own risk.
0
In order to have all of Server2 to be replicated to Server3:
Get rid of all binlog_(do/ignore) on Server2.
Get rid of all (replicate/binlog)_(do/ignore) on Server3.
Top 50 recent answers are included