1.1. Features
MySQL is a DBMS that has gained popularity for a number of attractive features:
• It is developed in C / C + +.
• The API is available in C, C + +, Eiffel, Java, Perl, PHP, Python, Ruby and TCL.
• equipment is optimized for multiple processors.
• It is very remarkable speed of response.
• Can be used as a client / server or embedded in applications.
• It has a rich set of data types.
• Supports multiples methods of storage of the tables, with different features and performance to optimize the DBMS to each case.
• Its management is based on users and privileges.
• There are records of cases handled fifty million records, sixty thousand five million tables and columns.
• Its connectivity options include TCP / IP, sockets, UNIX and NT sockets, in addition to fully support ODBC.
• Error messages may be in Spanish and make correct order with accented or the letter 'N'.
• It is highly reliable in terms of stability is concerned.
For those who are adherents to the philosophy of UNIX and C / C + +, the use of MySQL will be very familiar, since their design and their interfaces are consistent with this philosophy: "to create tools that do one thing and that make it right. "MySQL's main objective is to be a database of reliable and efficient. No feature is implemented in MySQL without first it is certain that will work with the best speed of response and, of course, without causing stability problems.
The influence of C / C + + and UNIX can be seen equally in its syntax. For example, the use of regular expressionsdifferentiation of functions by the parentheses, the logical values 0 and 1, use Tab to complete sentences, to name a few.
