Subscribe
Free Knowledge in an RSS feed

Articles » MySQL Tutorials

Great OS X MySQL Client

January 8th, 2012

Check out this awesome OS X MySQL client!

Simple PHP MySQL Script

May 28th, 2011

This is a very simple PHP script for working with MySQL databases. I first wrote it back in 2005.

MySQL REPLACE vs INSERT ON DUPLICATE KEY UPDATE

February 26th, 2011

Recently, while working on ObsceneArt, we had the need to quickly either insert new data into a database, or update an existing record, specifically used for the rating system. For example, when a user would rate a quote, they might have already rated it once and would like to change their mind, or they would [...]

PHP / MySQL Web Application Migration Steps

October 7th, 2010

I was recently asked how easy it is to move a web application based on the PHP/MySQL realm of web application development. When moving a static website, one can “drag and drop” the website from one location to another, and things usually work just fine, so surely moving a web app is this easy? Unfortunately, [...]

Database Administration using phpMyAdmin

October 18th, 2009

This document will cover various database administration activities using phpMyAdmin (PMA for short). This covers three levels of administration; database level, table level, and row (data) level. PMA is a database front end for the popular database language/architecture MySQL. PMA itself is written in the equally popular server-side language PHP.

Free MySQL database of all countries

October 16th, 2009

This is a database dump of all countries, along with their 2 digit country code. There are 246 countries total, sorted alphabetically. The database dump has three columns, the first is a primary numeric key set to autoincrement. The second is the two character abbreviation of the country. The third column is the name of [...]

Changing MySQL Default Character Sets

August 20th, 2009

How to change your default character sets in MySQL.

MySQL Fulltext Search Ignored Words

September 2nd, 2008

This is a comprehensive list of words that are ignored by MySQL’s fulltext search by default. This list is known as stopwords and are ignored because they are too common. (Also ignored are words that are three or less characters long).