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

The following mainly brings you some basic knowledge of mysql database. I hope these contents can bring you practical use. This is also the main purpose of this article that I edit some basic knowledge of mysql database. All right, don't talk too much nonsense, let's just read the following.

MySQL database

Database

DBS-DataBase System database system

Store data as a relational (two-dimensional table)

Record Record

Field / property Column

Database

Constraint Constraint

Domain constraints: data type constraint

Ensure that the data types of a field are consistent

Foreign key constraints: referential integrity constraints (InnoDB)

Data for a field in a table must exist in the associated fields of other tables associated with it

Primary key constraint

A field uniquely identifies the entity to which this field belongs and is not allowed to be empty

A table can have only one primary key

Unique key constraint

A field can uniquely identify the entity to which this field belongs, and can be empty

A table can have multiple unique keys

Checking constraint

Ensure that there is no counterintuitive data, such as age, in a field

Transaction Transaction

Guarantee data ACID attribute

Database management software:

Oracle, MySQL, MariaDB (Percona), DB2, HBase, SQ512L Server (relational database management software)

NoSQL (non-relational database) Redis, MongoDB, Memcached

SQL statement structured query statement:

DDL data definition language

DML data manipulation language

DCL data control language

MySQL storage engine Storage Engine

Support for plug-in storage engine

MyISAM

Transactions are not supported, only table-level locks are supported

Foreign keys are not supported

Support B-tree index, full-text FULLTEXT index, spatial index

Support for table compression

Good performance, suitable for more queries (data warehouse)

InnoDB

Support transactions to ensure that multiple operations are executed successfully at the same time

Support for row-level locks

Support for using tablespaces (Table Space)

Support for raw disk devices (devices without file systems)

Suitable for online transaction processing system (online transaction system OLTP)

MRG_MYISAM

Merge two or more MYISAM tables (with a consistent table structure) into a single table using the

CSV

Save the table as a text file

Use when migrating databases

ARCHIVE

For data mining

MEMORY

All tables are stored in memory

Used to create temporary tables

Transactions, distributed transactions, checkpoints are not supported

BLACKHOLE

MySQL master-slave replication architecture

Hybrid storage engine is not recommended, that is, the storage engine of all objects should be consistent.

For the above basic knowledge of mysql database, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

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.