表结构语句操作
(1)创建表create table student(id int,name varchar(20),sex varchar(20),age int,salery float(6,2),birthday date)
(2)删除表drop table student;
(3)查看所有表show tables
数据库操作语言
1.1. 插入数据
insert into student2 values(1,‘张三’,‘男’,19,389.10,‘1999-10-10’,89,77,66)
insert into student2 values(2,‘李四’,‘男’,19,389.10,‘1999-10-10’,65,78,98)
insert into student2 values(3,‘张浅’,‘女’,19,389.10,‘1999-10-10’,67,86,79)
insert into student2 values(4,‘李欣’,‘女’,19,389.10,‘1999-10-10’,99,64,75)
inser