How to Bring Back GROUP BY in MySQL
If you are suddenly not able to perform GROUP BY statements as you used to after a MySQL/MariaDB version update, then you will have noticed the change …
MySQL
42 articles about mysql development, tools, and best practices
How to Purge the BinLog for MySQL and MariaDB
If you see lots of disk space quickly disappearing on your MySQL or MariaDB server, then you may want to look into the BinLog directory, it is located …
How to Delete from a Table where rows match in Another Table – MySQL
So you have a table where you want to delete a bunch of rows, based on a particular column being matched in another table.
This is easily achievable …
Read Article →REPLACE INTO instead of INSERT INTO – MySQL
There are many occasions where you need to INSERT a record into a MySQL database table, but the record already exists.
INSERT INTO queue_domains …
When to use FLUSH PRIVILEGES in MySQL
So if you’ve ever created users and given them specific permissions from with SQL or the commandline, you will be familiar with a statement …
Read Article →MySQL Community Server MSI Installer Hangs on Windows 10
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 Article →Let Joomla and MySQL interact!
I often need a quick and easy few lines to retrieve some data from MySQL using Joomla without all the MVC nonsense that usually goes about this topic. …
Read Article →How to backup all mysql databases
In order to backup all mysql databases, you can run the following command in your linux command line:
The example below is configured with username …
Read Article →Unable to connect to any of the specified MySQL hosts.
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 …
Read Article →LEN in MySQL
Coming from SQL Server or MS Access? You might be looking for LEN() to get the length of a string. In MySQL, it’s called LENGTH() instead.
You …
Read Article →MySQL Error: Can’t get hostname for your address
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 to the IP not being able to …
Read Article →..near 'option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.o' at line 1
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 an …
Read Article →MSSQL Select Not Null
I mainly use MySQL these days, so get screwed over for a few minutes when I have to do something in MSSQL that is slightly different when it comes to …
Read Article →MySQL Main Query Types used in PHP to select, insert, update and delete data
MySQL Main Query Types
SELECT
SELECT * FROM tablename
INSERT
INSERT INTO tablename (col1, col2, col3,..) VALUES (val1, val2, val3,...)
UPDATE
UPDATE …Connect to mysql database from php
If you need to connect to a mysql database from php you can do it like this:
<?php
$DBH = 'localhost';
$DBU = 'root';
$DBPWD = …Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource
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 …
Read Article →mySQL select multiple ids
If you need to fetch several rows by their IDs in a single query, use the IN clause instead of chaining multiple OR conditions. It’s cleaner and …
mySQL Development Tools
I came across a very interesting article about MySQL development tools — a solid roundup of admin and management tools that were popular at the time. …
Read Article →