I was trying to install MySQL Community Server for Windows 10 using the standard .MSI installer provded from the MySQL website and the installer just… Read More »MySQL Community Server MSI Installer Hangs on Windows 10
From time to time you might have some rather big tables that you want to delete all the data quickly and start afresh. You have… Read More »Faster alternative to MySQL Delete Table Contents / Truncate
At Statvoo we found ourselves in the position where we needed to move our master MySQL database without ANY downtime and for anyone who’s tried… Read More »Moving a MySQL Database without downtime
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,… Read More »Unable to connect to any of the specified MySQL hosts.
This error is thrown by MySQL because it tries to do a DNS lookup on the address connecting to the server and it fails due… Read More »MySQL Error: Can't get hostname for your address
So you’ve just installed Opencart 1.5.0 and when attempting to edit a product or category or etc you get the following error: Error: You have… Read More »..near 'option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.o' at line 1
MySQL Main Query Types SELECT SELECT * FROM tablename INSERT UPDATE DELETE Note You will use a lot of WHERE clauses as well along with… Read More »MySQL Main Query Types used in PHP to select, insert, update and delete data
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource You have just gotten a warning when trying to check if an inserted row was… Read More »Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource