【MySQL2】

-- 1、选择mydb1
use mydb1;
-- 2、创建表
create table if not exists student(
id int,
name varchar(20),
gender varchar(20),
age int,
birth date,
address varchar(20),
score double 
);
-- 3、查看当前数据库所有表
show tables;
-- 4、查看指定表创建语句
show create table student;
-- 5、查看表结构
desc student;
-- 6、删除表
drop table student;
-- 7、添加列
alter table student add dept varchar(20);
-- 8、修改列名和类型
alter table student change dept department varchar(30);
-- 9、删除列
alter table student drop department;
-- 10、修改表名
rename table stu to student;

-- DML操作
-- 1、数据插入
insert into student (id,name) values(1001,'小王');
insert into student values(1002,'小张','男',12,'1996-12-23','北京',98.0);
insert into student values(1003,'小张','男',12,'1996-12-23','北京',98.0),
                          (1004,'小张','男',12,'1996-12-23','北京',98.0),
                          (1005,'小张','男',12,'1996-12-23','北京',98.0);
-- 修改数据
update student set address='重庆';
update student set address='北京' where id=1004;
update student set address='广州’,score= where id=1005;