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 [...]

Alot of folks have problems when they first transfer to Oracle from MySQL.
Most of those problems are cosed by absence of LIMIT.
Just to give you all a hint in the right direction here is the simplest “pagination” query used on Oracle.
(select * from emp
where rownum

We had few problems with a huge database table (1600k rows of data). Basically problem was with invalid dates.
Our database is receiving data over serial port so there was Alot of garbage. Sice it’s such a huge table and there was so much invalid date formats I was forced to create decent Oracle replacement for [...]

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 [...]