Main features of MySQL

Some important features of MySQL:

• Use the fully multilinear core linearity. This means that it can easily take advantage of multiple CPUs if there is ).
• C, C ++, Eiffel, Java, Perl, PHP, Python, and TCL APIs. See 20 MySQL client tools and APIs.
• It can run on different platforms. For details, see the Operating System Supported by MySQL 4.2.
• Multiple column types: 1, 2, 3, 4, and 8-byte signed/unsigned integer, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, and ENUM types.
• Using an optimized one-time scan of multiple joins one-sweep multi-join), join is performed very quickly ).
• All operators and functions are supported in the SELECT and WHERE clauses of the query, for example:

  mysql> SELECT CONCAT(first_name, " ", last_name) FROM tbl_name WHERE income/dependents > 10000 AND age > 30;

• The SQL function library is implemented through a highly optimized class library and is as fast as they can achieve. Generally, no memory allocation should be made after the query initialization.

• Fully supports SQL GROUP BY and ORDER BY clauses, and supports aggregate functions (COUNT (), COUNT (DISTINCT), AVG (), STD (), SUM (), MAX () and MIN ()).
• Supports the left outer join and ODBC Syntax of ansi SQL.
• You can mix tables from different databases in the same query.
• A flexible and secure permission and password system that allows host-based authentication. The password is safe, because when connected to a server, all the password transmission is encrypted.
• ODBC for Win32. All ODBC 2.5 functions and many other functions. For example, you can use Access to connect to your MySQL server.
• A Fast B-tree table with index compression.
• Each table can have 16 indexes. Each index can be composed of 1 ~ Consists of 16 columns or a part of a column. The maximum index length is 256 bytes (which can be changed when MySQL is compiled ).
• An index can use the pre-code of a CHAR or VARCHAR field.
• Fixed Length and variable length records.
• The memory hash used as a temporary table.
• Big database processing. We are using MySQL for some databases that contain 50,000,000 records.
• All columns have default values. You can use INSERT to INSERT a subset of a table column. columns that do not explicitly set values are set as their default values.
• Use GNU Automake, Autoconf, and libtool for portability.
• It is written in C and C ++ and tested with a large number of different compilers.
• A very fast linear memory allocation system.
• No memory vulnerabilities. Tested with a commercial memory vulnerability Monitor (purify ).
• Including myisamchk, a quick utility for checking, optimizing, and repairing database tables.
• Full support for ISO-8859-1 Latin1 character set. For example, the Nordic characters a, a and o are allowed in the table and column names.
• All materials are saved in ISO-8859-1 Latin1 format. All normal strings are case-insensitive.
• Sort by ISO-8859-1 Latin1 character set (current Swedish method ). You can change the sorting sequence array by adding it to the source program. To understand a more advanced sorting example, let's take a look at the Czech sorting program. MySQL supports many different character sets that can be specified during compilation.
• Aliases of tables and columns comply with SQL92 standards.
• The number of rows returned by DELETE, INSERT, REPLACE, and UPDATE is changed (affected ).
• The function name does not conflict with the table or column name.
• The server can provide users with error messages in multiple languages.
• User end uses TCP/IP connection or Unix socket) or named pipe under NT to connect to MySQL.
• The SHOW command specific to MySQL can be used to retrieve information about databases, tables, and indexes. The EXPLAIN command can be used to determine how the optimizer solves a query.