MySQL is a database system that is most used, fast, more reliable, cheaper, and better than any other database system.
It has a relational database system.
SQL compatibility (Structured Query Language) .MySQL has the features of the current SQL standard (at the moment SQL: 2003).
SubSELECTs: From version 4.1, MySQL is capable of processing a query in the form of SELECT * FROM tablename1 WHERE x IN (SELECT y FROM tablename2).
MySQL supports views from MYSQL version 5.0.
Stored procedures: Is capable of storing codes: MySQL has supported SPs since version 5.0.
Triggers: MySQL has supported triggers in a limited form from version 5.0
Unicode: MySQL has supported all conceivable character sets since version 4.1, including Latin-1, Latin-2, and Unicode (either in the variant UTF8 or UCS2).
User interface: There are a number of convenient user interfaces for administering a MySQL server.
Full-text search: Full-text search simplifies and accelerates the search for words that are located within a text field. If you employ MySQL for storing text (such as in an Internet discussion group), you can use full-text search to simply implement an efficient search function.
Has got statement-based replication.
It's one of the simplest ways to create databases.
Room for Improvement:
DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are non deterministic.
Statements using any of the following functions cannot be replicated properly using statement-based replication: LOADFILE (), USER ().
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jul 13 2012