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.
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: 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
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.
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
MySQL Foreign Key Tutorial
July 9th, 2016Here's a quick tutorial on creating foreign keys with MySQL.
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.