如下只介绍单表的添加、更新、删除、查询表结构操作，查询数据操作范围太大用单独的篇幅来讲解；

查看表结构

desc test_tb;

Insert 插入数据

插入 = 添加

Create table student(

    id int(4),

    name varchar(20) not null,

    grade float

);

Insert into test_tb(id,name,grade) values(1,"lisi",98);

不指定字段，就相当于每个字段都要填充上值才行；

Create table student(

    id int(4),

    name varchar(20) not null,

    grade float

);

Insert into test_tb values(1,"lisi",98);

# 由于没有指定字段，那么顺序和数量一定得和表中的字段顺序、数量都得一致；

批量插入

Create table student(

    id int(4),

    name varchar(20) not null,

    grade float

);

Insert into test_tb(id,name,grade) values(1,"lisi",98),(2,"wangwu",60),(1,"chenliu",76);

Update test_tb Set age=18,sex=1

Update test_tb Set age=18,sex=1 where id=1;

Delete from test_tb;

Delete from test_tb where id = 1;