MySql基本使用指令

1.启动MySql

/etc/init.d/mysql start

运行成功显示：

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

2.运行

mysql -u root -p

启动成功：

[ ok ] Starting mysql (via systemctl): mysql.service.

3.创建数据库firstDb

mysql->create database firstDb;

4.显示已创建的数据表

mysql->show database;

显示：

+--------------------+
| Database           |
+--------------------+
| information_schema |
| firstDatabase      |
| firstDb            |
| firstdb            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
7 rows in set (0.08 sec)

5.使用创建的数据库，也就是后面的操作是基于这个数据库

mysql->use firstDb

6.创建一个表并添加内容，注意使用的是括号，可以一行一行输入，结构比较清楚，最后再输入分号“;”按回车，即可完成class表的创建。MySql关键字不区分大小写。

create table class（
    -> teacher_num INT,
    -> teacher_name VARCHAR(8),
    -> student_num INT,
    -> student_name VARCHAR(20),
    -> GoodStudent TINYINT）;

7.用show tables 列出数据库所有的的表

mysql->show tables;

+-------------------+
| Tables_in_firstDb |
+-------------------+
| class             |
+-------------------+
class即为之前创建的表。

8.检查表结构

mysql> describe class;

9.向表中添加数据

（1）不需要按顺序输入：
mysql> insert into class(teacher_num,teacher_name,student_num,student_name,GoodStudent)VALUES(1,'Peter',20,'finee',14);
（2）需要按顺序输入也就是VALUES后的值与表中字段的顺序是一致的：
mysql> insert into class VALUES(1,'Peter',20,'finee',14);
（3）输入多组数据：
mysql> insert into class VALUES(1,'Peter1',20,'finee1',14)，
VALUES(1,'Peter2',20,'finee2',14)，
VALUES(1,'Peter3',20,'finee3',14);