MySQL latest manual tutorial

"MySQL Development Manual" is the latest official MySQL online reference manual. It contains detailed explanations of various knowledge points such as additions, deletions, modifications, and indexes of the MySQL database. It is an indispensable online query reference document for MYSQL users and learners!

MySQL is a relational database management system developed by the Swedish MySQL AB company and is currently a product of Oracle.

MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system. A relational database stores data in different tables instead of placing all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases.

MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed and low total cost of ownership, especially the open source feature, the development of small and medium-sized websites is generally Select MySQL as the website database.

Tips: Before starting this tutorial, you should understand the basic knowledge of PHP and HTML and be able to apply it simply . Many examples in this tutorial are related to the PHP language. Our examples basically use the PHP language for demonstration.

MySQL system features

1. Written in C and C, and tested using a variety of compilers to ensure the portability of the source code.

2. Supports AIX, FreeBSD, HP-UX, Linux, Mac OS, NovellNetware, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems.

3. Provides APIs for multiple programming languages. These programming languages ​​include C, C, Python, Java, Perl, PHP, Eiffel, Ruby, .NET and Tcl, etc.

4. Supports multi-threading and makes full use of CPU resources.

5. Optimized SQL query algorithm, effectively improving query speed.

6. It can be used as a separate application in a client-server network environment, or it can be embedded into other software as a library.

7. Provides multi-language support. Common encodings such as Chinese GB 2312, BIG5, Japanese Shift_JIS, etc. can be used as data table names and data column names.

8. Provides multiple database connection channels such as TCP/IP, ODBC and JDBC.

9. Provides management tools for managing, checking, and optimizing database operations.

10. Supports large databases. Can handle large databases with tens of millions of records.

11. Supports multiple storage engines.

12. MySQL is open source, so you don’t need to pay extra.

13. MySQL uses the standard SQL data language form.

14. MySQL has good support for PHP, which is a popular web development language.

15. MySQL can be customized and adopts the GPL protocol. You can modify the source code to develop your own MySQL system.

16. Online DDL/change capabilities, data architecture supports dynamic applications and developer flexibility (new in 5.6)

17. Copy global transaction identifiers to support self-healing clusters (new in 5.6)

18. Copy crash-free slaves to improve availability (new in 5.6) )

19. Copy multi-threaded slaves to improve performance (new in 5.6)

20. 3 times faster performance (new in 5.7)

21. New optimizer (new in 5.7)

22. Native JSON support (new in 5.7)

23. Multi-source replication (new in 5.7)

24. Spatial expansion of GIS (new in 5.7)

New features

1. Partitioning of tables and indexes

2. Row-level replication

3. MySQL base cluster disk-based data support

4. MySQL cluster replication

5. Enhanced full-text search function

6. Enhanced information schema (data dictionary)

7. Pluggable API

8. Server log table

9. XML (subset of Standard Universal Markup Language)/XPath support

10. Instance Manager

11. Table space backup

12. mysql_upgrade upgrade program

13. Internal task/event scheduler

14. New performance tools and options such as mysqlslap

What this MySQL tutorial manual covers

This tutorial covers all MySQL basic knowledge points, including additions, deletions, and modifications to the MySQL database Detailed explanation of various knowledge points such as searching, indexing, etc.

Tips: Each chapter of this tutorial contains many MySQL examples, you can try to use the online editor for testing. These examples will help you better understand and operate the MySQL database.

Other MySQL-related learning reference resources

In addition to the knowledge expansion on the right side of this page, the following resources are also selected for everyone

1. MySQL Authoritative Development Guide (Tutorial)

2. MySQL Daily Programming Tips

3. Introduction to six powerful PHP/MYSQL code generators

4. Summary of mysql download and installation tutorials (the most complete in history, constantly updated...)