MySQL Tour "first article"

1, basic operation

1 Create databades  database name;  #创建数据库 23show databases;  #显示存在的数据库 45 drop  database name   #删除数据库

2, Database Storage Engine Introduction

1 show engines \g; 2 3 ' have% ' ; 4 5 querying MySQL-supported storage engines

InnoDB Storage Engine

InnoDB storage Engine, the structure of the created table is stored in the. frm. Data and indexes are stored in table spaces defined by Innodb_data_home_dir and Innodb_data_file_path

The advantage of the InnoDB storage engine is that it provides good handling of things, crash repair, and concurrency control. Disadvantage is poor read and write efficiency, take up the data space is large

MyISAM Storage Engine

The table for the MyISAM storage engine is stored as 3 files. The name of the file is the same as the name of the table.

The advantage of the MyISAM storage engine is that it takes up little space and processing speed, but does not support transactional integrity.

Memory storage engine (not used)

3, for the common storage engine how do we choose?

If the required integrity is high and concurrency control is required, select the InnoDB storage engine because it enables transaction commit and rollback

If the requirements are mainly used to insert new records and read the record, select MyISAM is better, if the application type concurrency is very low, you can also choose MyISAM

MySQL Tour "first article"