MysqL learning instance _ MySQL

I haven't talked about database skills for a long time in mysqL learning examples. of course, I am not a master. so I can't help myself with that sentence! Haha!
I. operation skills

1. if you forget the extra points after you press enter when making the command, you don't have to repeat the command. you just need to press a semicolon to press Enter. That is to say, you can divide a complete command into several lines, and then use a semicolon as the end sign to complete the operation.

2. you can use the cursor to bring up or down the previous commands. However, an old MYSQL version I used earlier does not support this feature. I am using a mysql-3.23.27-beta-win.

II. display commands

1. display the database list.

Show databases;

2. display the data tables in the database:

Use mysql; // open the database

Show tables;

3. display the data table structure:

Describe table name;

4. database creation:

Create database name;

5. create a table:

Use database name;

Create table name (field setting list );

6. delete databases and tables:

Drop database name;

Drop table name;

7. clear records in the table:

Delete from table name;

8. display records in the table:

Select * from table name;

3. an instance for creating a database, creating a table, and inserting data

Drop database if exists school; // delete if SCHOOL exists

Create database school; // create a database SCHOOL

Use school; // open the SCHOOL library

Create table teacher // create table TEACHER

(

Id int (3) auto_increment not null primary key,

Name char (10) not null,

Address varchar (50) default 'shenzhen ',

Year date

); // Table creation ends

// Insert fields as follows

Insert into teacher values ('', 'glengang ', 'Shenzhen Zhongyi', '2017-10-10 ');

Insert into teacher values ('', 'Jack', 'Shenzhen Zhongyi ', '2017-12-23 ');

Note: In fact, MYSQL's database operations are similar to those of other SQL databases. you 'd better read this SQL book. I am a lazy person. besides, I have been busy with my recent work and busy with the processing of the recording and telephone system!

Green channel: please follow my favorites to contact me