一、MySQL 简单到不能再简单的基础语句:
- information_schema 对象信息 列信息,用户信息,权限信息,字符集
- mysql 用户的权限信息
- test 测试
- cluster 集群信息
①DDL
数据定义语言 create drop alter
②DML
数据操纵语言 insert delete update select
③DCL
数据控制语言 grant revoke
1).DDL(create drop alter)
(1.创建数据库 create database Cy1703;
(2.查询数据库 show databases;
(3.删除数据库 drop databases Cy1703;
1.建表
create TABLE Stu(
id varchar(20) primary key,
name varchar(20) not null,
age int default null,
sex varchar(8),
score float );
2.删除表
drop TABLE tablename;
3.查询表结构
show Create table tablename;
4.表的修改alter
1.修改字段属性
alter table Stu MODIFY sex varchar(10);
2.添加字段
alter table Stu ADD height2 float not NULL AFter sex;
3.删除一个字段
alter table Stu DROP height2;
4.修改字段名称
alter table Stu CHANGE sex mysex enum("man","woman");
5.修改表名
alter table Stu RENAME student;
2).DML( insert|load|replace delete update select)
1.数据插入
insert into Stu value("zhangsan",10,"man",98.6);
insert into stu(name,mysex) value("lisi","man");
insert into stu value("zhangsan",10,"man",78.1),
("lisi",10,"man",98.6),
("lisi",10,"man",59.4),
("lisi",10,"man",65.5);
2.数据的删除
1.删除表中的所有数据
delete from stu;
2.删除符合条件的数据
delete from stu where name = "lisi";
3.数据的修改
update stu SET score = 76 where name = "zhangsan";
4.数据的查询
- select * from Stu;//查询所有
- sele