Shulou(Shulou.com)06/01 Report--

MySQL is a relational database management system developed, released and supported by Oracle.

1. MySQL is a database management system

A database is a collection of structured data, which can be a simple picture of a shopping list or a large amount of information in a company's network. In order to add, access and process the data stored in the company's database, you need a database management system, such as MySQL server. Because computers are very good at dealing with large amounts of data, database management systems play a very central role in computing as part of independent utilities or other applications.

2. MySQL database is relational.

A relational database stores data in different tables instead of storing all the data in a large storage area. In order to improve the storage speed, structured data is organized and stored in physical files. Logical models of objects such as databases, tables, views, rows, and columns provide a flexible programming environment. You can set corresponding rules in different data fields that point to different tables, such as one-to-one, one-to-many, unique, necessary, and optional. The database enforces these rules, so in a well-designed database, the application will never see inconsistent, duplicate, or isolated, out-of-date, or lost data.

The SQL part of MySQL corresponds to a structured query language, and SQL is the most common standardized language for accessing databases. Depending on your programming environment, you can type SQL directly (such as generating reports), embed the SQL language into other languages, or use the API of a particular language to hide the SQL syntax.

SQL is defined according to the ANSI/ISO SQL standard. Since 1986, the SQL standard has been developing continuously, and now there are several versions, such as 92 version of the standard, 99 version of the standard and 2003 version of the standard, basically using the 2003 version of the latest standard.

3. MySQL software is open source.

Open source means that everyone can use and modify the software. Everyone can download and use MySQL on the Internet for free. You can learn and change the source code according to your personal needs. MySQL software uses the GPL protocol.

4. MySQL database server is fast, reliable, scalable and easy to use.

MySQL servers can be easily run on desktops or laptops with other applications, web servers, and so on, without special attention. If you want to use the entire machine for MySQL, you can adjust the MySQL settings to make full use of all memory, CPU capabilities, and available input and output capabilities. MySQL can also be extended to a set of machines and networked.

5. The MySQL server works in the client, server or embedded system

MySQL database software is a client / server system consisting of a multi-threaded SQL service that supports different backends, different client programs and libraries, management tools and a wide range of application program interfaces. MySQL servers can also be used as embedded multi-thread libraries that can be connected to applications for smaller, faster, and more manageable stand-alone products.

6. Provide a large number of MySQL software support

MySQL supports a large number of languages, and most application languages support MySQL software.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.