MYSQL CREATE database and CREATE TABLE do something!

Create Database Studio;

So that you can create a database, and what does he have to forgive?

You can see that it creates a folder, so let's go inside and see what's in it.

Let's just build a table and go inside, run this create table Nums (X int not null);

Content analysis:

db.opt file,

Copy it to another place, and the book opens.

It is found that it holds the character set and collation information.

. frm files,

It holds the definition of the entire table frame, but it holds ciphertext.

. IDB files,

It is used to save the data in the table.

MYSQL CREATE database and CREATE TABLE do something!