Tag: MySQL
MySQL Stored Procedure tutorial
July 30th, 2009An example of how to create and use a stored procedure with MySQL.
Install PHP and Mysql on OSX Mountain Lion
December 19th, 2012Here's a useful snippet to help install PHP and MySQL on OSX Mountain Lion.
Solved: Fix for MySQL error Code 1217 – A foreign key constraint fails
August 13th, 2014If you're getting the following from MySQL: 'Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails' - this is how to fix it
TIL: MySQL FLUSH PRIVILEGES isn’t needed
July 17th, 2015Today I learned that `FLUSH PRIVILEGES` isn't needed by Scott Lindsey in the comments. After double checking locally that Scott was correct I looked it up and found a great explanation why MySQL FLUSH PRIVILEGES isn't needed
How To Create a New User in MySQL 8
November 27th, 2020The command to create a new user on MySQL version 8 has changed. Heres how to do it.
Fix for mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')...
May 11th, 2023Recent updates to the `mysqldump`command may cause the error `SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS...` on MySQL 5.7. Here's how to fix that.
How to import a Google Sitemap into a MySQL table
May 30th, 2018Here's a quick snippet showing how to import a Google Sitemap file into a MySQL table. This is useful if you need to do anything with the urls such as scrape the pages or check for 301/302/404 results.
MySQL Create Database with UTF8 Character Set Syntax
June 21st, 2013I always forget the MySQL create database with UTF8 character set syntax, so here it is.
Solved: MySQL fix for "Field ‘xxxx’ doesn’t have a default value"
June 22nd, 2015If you're using MySQL and getting the following error "SQLSTATE[HY000]: General error: 1364 Field 'delivery_address_id' doesn't have a default value" then this is how to fix it.
MySQL Foreign Key Tutorial
July 9th, 2016Here's a quick tutorial on creating foreign keys with MySQL.