Articles » MySQL Tutorials
Database Administration using phpMyAdmin
October 18th, 2009This 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, 2009This 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, 2009How to change your default character sets in MySQL.
MySQL Fulltext Search Ignored Words
September 2nd, 2008This 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).