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

This article mainly explains "what are the characteristics of MySQL". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the characteristics of MySQL".

Database and SQL concept

Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It has been more than 60 years since it came into being. With the development of information technology and market, database has become ubiquitous: it is widely used in e-commerce, banking system and many other fields, and has become an important part of its system.

The database is used to record data, and the data recorded in the database can show the relationship between all kinds of data, and it is also convenient to add, delete, change, check and so on the recorded data.

Structured query language (Structured Query Language), referred to as SQL, is a language developed by IBM Company in the 1970s to operate the database. More specifically, SQL is a database query and programming language for accessing data and querying, updating and managing relational database systems, as well as an extension of database script files

MySQL introduction

MySQL is a DBMS (database management system) developed by MySQLAB Company of Sweden and currently belongs to Oracle Company. MySQL is the most popular relational database management system (relational database is a database based on relational database model, with the help of concepts and methods such as set algebra to deal with data in the database). Because of its small size, high speed and low total cost of ownership, especially open source, developers of small and medium-sized websites generally choose MySQL as the website database. MySQL operates in the SQL language.

SQL

Structured Query Language

SQL' is a structured query language and a database language for operating RDBMS. At present, all relational databases are supported to operate with SQL language, that is to say, all relational databases such as oracle,sql server,mysql,sqlite can be operated through SQL.

SQL statements are mainly divided into:

DQL: data query language for querying data, such as select**

DML: data manipulation language for adding, modifying, and deleting data, such as insert, udpate, delete**

TPL: transaction processing language for processing transactions, including begin transaction, commit, rollback

DCL: data control language for authorization and permission recovery, such as grant, revoke

DDL: data definition language for managing databases, tables, etc., such as create, drop

CCL: pointer control language that controls pointers to perform table operations, such as declare cursor

For web programmers, the focus is on the crud of data. They must be proficient in writing DQL and DML, and be able to write DDL to complete the operation of databases and tables. Other languages such as TPL, DCL and CCL can be understood.

SQL is a special language for operating relational databases.

Case insensitive

Learning requirement

Proficient in writing SQL sentences related to data addition, deletion, modification and query

To manipulate data in Python code is to manipulate data through SQL statements.

# create Connection connection conn = connect (host='localhost', port=3306, user='root', password='mysql', database='python1', charset='utf8') # get Cursor object cs = conn.cursor () # Update # sql = 'update students set name= "Liu Bang" > MySQL introduction

Click to view the official website of MySQL

MySQL is a relational database management system developed by MySQL AB in Sweden and later acquired by Sun. Sun was later acquired by Oracle and is now a product of Oracle.

Characteristics

Written in C and C++, and tested with a variety of compilers to ensure the portability of the source code

Support multiple operating systems, such as Linux, Windows, AIX, FreeBSD, HP-UX, MacOS, NovellNetware, OpenBSD, OS/2 Wrap, Solaris, etc.

API is provided for many programming languages, such as C, C++, Python, Java, Perl, PHP, Eiffel, Ruby, etc.

Support for multithreading and make full use of CPU resources

Optimized SQL query algorithm to effectively improve the query speed

Provide multilingual support, common encodings such as GB2312, BIG5, UTF8

Provide multiple database connections such as TCP/IP, ODBC and JDBC

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

A large database. Can handle large databases with tens of millions of records

Support for multiple storage engines

MySQL software adopts the dual license policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

MySQL uses the standard SQL data language form

Mysql can be customized, using the GPL protocol, you can modify the source code to develop your own Mysql system

Online DDL change function

Copy global transaction identity

Copy no crash slave

Copy multithreaded slave

Thank you for your reading, the above is the content of "what are the characteristics of MySQL", after the study of this article, I believe you have a deeper understanding of what the characteristics of MySQL are, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.