The characteristics and uses of MySQL Database

This article mainly gives you a brief talk about the characteristics and usefulness of MySQL database. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on the characteristics and usefulness of MySQL database can bring you some practical help.

First, the benefits of database to achieve data persistence using a complete management system for unified management, easy to query second, database-related concepts 1. DB

Database (database): in short, it can be regarded as an electronic filing cabinet-the place where electronic documents are stored, where users can add, query, update, delete and other operations on the data in the documents.

The so-called "database" is a collection of data that is stored together in a certain way, can be shared with multiple users, has as little redundancy as possible, and is independent of the application.

2. DBMS

Database Management system (Database Management System) is a large-scale software that manipulates and manages the database, which is used to establish, use and maintain the database, referred to as DBMS. It unifies the management and control of the database to ensure the security and integrity of the database.

Common database management systems are: MySQL, Oracle, DB2, SqlServer

3. SQL

Structured query language (Structured Query Language) is abbreviated as SQL (pronounced / pronounced eskju query el/ "S-Q-L"). It is a special purpose programming language and a database query and programming language for accessing data and querying, updating and managing relational database systems.

Advantages of SQL

Not a language proprietary to a particular database vendor, almost all DBMS supports SQL easy to learn, but it is actually a powerful language that uses its language elements flexibly to perform very complex and advanced database operations. Third, the characteristics of the database put the data into the table, and then put the table into the library. There can be multiple tables in a database, each with a name to identify itself. The table name is unique. Tables have features that define how data is stored in the table, similar to the design of "classes" in java. A table consists of columns, which we also call fields. All tables are made up of one or more columns, each similar to the "properties" in java. The data in the table is stored in rows, and each row is similar to an "object" in java. The characteristics and usefulness of MySQL database will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.