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
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