Important features of MySQL

1. Use full multithreading of core threads. This means that it can easily use multiple CPUs (if any ). 2. Supports customer tools and APIs such as C, C ++, Eiffel, Java, Perl, PHP, Python, and TCLAPI. 3. It can run on different operating system platforms. 4. Multiple column types are supported: 1, 2, 3, 4, and 8-byte characters

1. Use full multithreading of core threads. This means that it can easily use multiple CPUs (if any ). 2. Supports customer tools and APIs such as C, C ++, Eiffel, Java, Perl, PHP, Python, and TCL APIs. 3. It can run on different operating system platforms. 4. Multiple column types are supported: 1, 2, 3, 4, and 8-byte characters

1. Use full multithreading of core threads. This means that it can easily use multiple CPUs (if any ).

2. Supports customer tools and APIs such as C, C ++, Eiffel, Java, Perl, PHP, Python, and TCL APIs.

3. It can run on different operating system platforms.

4. multiple column types are supported: 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.

5. Use an optimized one-scan multi-join to quickly perform join operations ).

6. 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;

7. Use a highly optimized class library to implement the SQL function library and achieve the same speed as they can. Generally, there should be no memory allocation after the query initialization.

8. SQL GROUP BY and ORDER BY clauses are fully supported. Aggregate functions (COUNT (), COUNT (DISTINCT), AVG (), STD (), SUM (), and MAX () are supported () and MIN ()).

9. Supports the left outer join and ODBC syntaxes of ansi SQL. You can mix tables from different databases in the same query.

10. 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.

11. ODBC for Windiws 95. All ODBC functions and many other functions. For example, you can use Access to connect to your MySQL server and have a fast B-tree disk table with index compression.

12. 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 prefix of a CHAR or VARCHAR field.

13. Fixed Length and variable length records. The memory hash used as a temporary table.

14. Big database processing. We are using MySQL for some databases that contain 50,000,000 records.

15. 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.

16. It is written in C and C ++ and tested with a large number of different compilers, a very fast thread-based memory allocation system.

17. Full support for ISO-8859-1 Latin1 character set. For example, the Nordic character @ ringaccent {a} and @ "a and @" o are allowed in the table and column names.

18. aliases of tables and columns comply with SQL92 standards.

19. The function name does not conflict with the table or column name. For example, ABS is a valid column name.

20. The client uses a TCP/IP connection or a named pipe under Unix socket (socket) or NT to connect to MySQL.

21. 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.