MySQL Review

MySQL is a database system that is most used, fast, more reliable, cheaper, and better than any other database system.

Valuable Features:

It has a relational database system. Client/Server Architecture 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.
More MySQL reviews from users
...who work at a Computer Software Company
...who compared it with SQL Server
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: September 2021.
534,468 professionals have used our research since 2012.
Add a Comment
ITCS user

author avatarit_user3876 (Database Manager at a tech services company with 501-1,000 employees)

Would you please elaborate "statement-based" replication?

author avatarit_user1068 (Tech Support Staff at a tech company with 1,001-5,000 employees)

Indeed MySQL is an excellent database development open source program. From my point of view and experience using this program, it is the easiest to use and simplest to learn. The coding is just simple. However, I got a question.

When compared to SQL Server, how would you rate MySQL on the basis of coding and query language?

author avatarit_user2652 (Project Manager at a non-tech company with 10,001+ employees)
Top 20PopularVendor

I checked on statement-baesd replication and I am able to track down as below:-
Replication capabilities in MySQL originally were based on propagation of SQL statements from master to slave. This is called statement-based replication (often abbreviated as SBR), which corresponds to the standard statement-based binary logging format. In MySQL 5.1.4 and earlier, binary logging and replication used this format exclusively.

author avatarit_user4401 (Developer at a transportation company with 1,001-5,000 employees)

Related to security, can you tell me if MySQL has built-in authentication against LDAP directories?

author avatarit_user116742 (Oracle Web Administrator at a tech services company with 1,001-5,000 employees)

It is the easiest to use and simplest to learn. The coding is just simple.