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.

5 Comments

it_user3876ConsultantPOPULAR

Would you please elaborate "statement-based" replication?

03 February 13
it_user1068VendorLEADERBOARD

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?

23 June 13
kapilmalik1983ConsultantTOP REVIEWER

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.

27 July 13
it_user4401VendorPOPULAR

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

24 June 14
it_user116742Real UserTOP 10

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

25 June 14
Guest
Why do you like it?

Sign Up with Email