If you get the following error while trying to connect to a MySQL database using a third party client such as TOAD or SQL Workbench, then you need to edit your mysql server’s my.cnf file. Error Message: Unable to connect to any of the specified MySQL hosts. So open the my.cnf file by running a
Read More…
If you have a table which has duplicate items in then you can use the below statement to select them. SELECT * FROM tableName GROUP BY columnName HAVING ( COUNT( columnName) >1 )
I was trying to install Microsoft SQL Server Management Studio Express (what a long name) on a machine and kept getting error 29506 right near the end with a Rollback action thereafter. To get this program installed you will need to run Command Prompt as Administrator and then run the MSI (installer) from there. Navigate
Read More…
