1.登录数据库进入到本地mysql的安装目录bin文件夹下输入登录命令/usr/local/mysql-8.0.20-macos10.15-x86_64/bin/mysql -u root -p输入登录密码登录成功界面如下2.查看所有库命令show databases;(test库之前已经建好了)3.创建以及切换新库创建新库命令create database test;切换为新库命令use test;4.创建新的表创建表命令create table 表名字段英文名 数据类型 是否非空 字段为空时的默认值 指定主键如下图插入数据有2种方式1.insert into Studentv values(‘01’ , ‘赵雷’ , ‘1990-01-01’ , ‘男’),(‘02’ , ‘钱电’ , ‘1990-12-21’ , ‘男’),(‘03’ , ‘孙风’ , ‘1990-05-20’ , ‘男’),(‘04’ , ‘李云’ , ‘1990-08-06’ , ‘男’),(‘05’ , ‘周梅’ , ‘1991-12-01’ , ‘女’),(‘06’ , ‘吴兰’ , ‘1992-03-01’ , ‘女’),(‘07’ , ‘郑竹’ , ‘1989-07-01’ , ‘女’),(‘08’ , ‘王菊’ , ‘1990-01-20’ , ‘女’);2.insert into Student values (‘01’ , ‘赵雷’ , ‘1990-01-01’ , ‘男’);insert into Student values (‘02’ , ‘钱电’ , ‘1990-12-21’ , ‘男’);insert into Student values (‘03’ , ‘孙风’ , ‘1990-05-20’ , ‘男’);insert into Student values (‘04’ , ‘李云’ , ‘1990-08-06’ , ‘男’);insert into Student values (‘05’ , ‘周梅’ , ‘1991-12-01’ , ‘女’);insert into Student values (‘06’ , ‘吴兰’ , ‘1992-03-01’ , ‘女’);insert into Student values (‘07’ , ‘郑竹’ , ‘1989-07-01’ , ‘女’);insert into Student values (‘08’ , ‘王菊’ , ‘1990-01-20’ , ‘女’);第1种如下图第2种如下图5.查看表相关的命令showtables;--查看当前数据库的所有表desc表名;--查看表结构