New answers tagged

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