Since my last post with updated list of countries in MySQL format was so well received I decided to go even further and write a parser script so you can always get fresh countries list.
Every time you download sql countries list it will be up to date for that very minute. This is because it [...]

Just collected list of countries and formatted it into MySQL form… well nothing much but I bet it will be useful to someone out there. Well enjoy: Countries List SQL download

Even fresher SQL Countries list… here.

On different MySQL table engines different rules apply. For example on MyIsam you can have Full Text indexes (thus enabling full text search) but you are giving up foreign keys.
I searched the way to get both on out-of-the-box mysql but failed (this can be enabled with use of sphinx mysql plugin). The best thing I [...]

MySQL has had FULLTEXT searching in one form or another since version 3.23.23. FULLTEXT indices in MySQL allow database administrators and programmers to designate any character-based field (CHAR, VARCHAR, or TEXT) as a FULLTEXT index, which allows for complex text searching against data stored in those fields.
This feature is not to be confused with the [...]

In first part I talked about the basis of referential integrity, in this part I will go through few practical examples.
For start we will create on table that we will call ‘news’ and then insert few rows
CREATE TABLE news (id TINYINT NOT NULL AUTO_INCREMENT,
title VARCHAR(50), body VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE=INNODB;
Query OK, 0 rows [...]