Introduction 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. You can also download a PDF [...]
Browsing the archives for the MySQL Tutorials category
http://renownedmedia.com/blog/database-administration-using-phpmyadmin/
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 [...]
http://renownedmedia.com/blog/free-mysql-database-of-all-countries/
I’ve recently began building databases which require multilingual support. What this means is that the default MySQL Collation of “latin1_swedish_ci” just isn’t cutting it anymore. What I needed to do is enable Unicode support in my text tables (not to mention language management, but that’s a whole different story). Here is what you do to change [...]
http://renownedmedia.com/blog/changing-mysql-default-character-sets/
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).
http://renownedmedia.com/blog/mysql-fulltext-search-ignored-words/
