Create a message database
Then we use the command to view all databases
In this way our database Creation completed
We need to select the database first and then operate it, such as creating a table
use message;
such and that We can operate the database
Let’s create a user table, id username password
CREATE TABLE user(
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(10) NOT NULL,
password VARCHAR(32) NOT NULL,
PRIMARY KEY (id)
);
In this way, our user table has been created
The information about our messages must be stored in a table, let’s analyze it now
Id
Title 10 digits
Content 10 digits
Message time
Let’s create this table.
The table name is mess
CREATE TABLE mess(
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(10) NOT NULL,
content VARCHAR(200) NOT NULL,
messtime INT(11) NOT NULL,
PRIMARY KEY (id)
);
In this way, our message table is completed. Next, we can view the message database on the web management terminal to see whether the two tables we created have been completed.
In this way, our two tables have been created
Next Section