mysql------常用命令

mysql 基础：
数据库存储结构：
先有数据库，再有表，再有数据
管理数据库：
SQL语句：5个语句
show databases;
create databases day15
default character set utf8;
drop database day15;
show create database day15;
alter database day15 default character set gbk;
管理表：
use day15;


create table student(id int,name varchar(20),gender varchar(2));


drop table student;


alter table student add column jsp int;
alter table student drop column gender;
alter table student modify column gender varchar(2);
alter table student change gender sgender varchar(20);
alter table student rename to teacher;


show tables;
desc student;


管理数据：
insert into student (id,name) values(2,'lisa');


delete from student where  id=2;


update student set gender='男',id=3,where name='lisa';


select * from student;
select id ,name from student;
select id as '编号', name as '姓名' from student ;
select id,name,(jsp+servlet+javabean ) from student;
select distinct id,from student;
select id,name from student where id=1 and name='张三丰';
select id,name from student where (jsp+servlet+jeavabean) >50;
select *　from student where id betweeen 2,10;
select * from student where address is not null;
select * from student where address id null and address='';
select * from student where address<>'';
select * from student where name like 'li%';
select * from studet where name like 'li__';
select * from student limit 2,2;
select * from student order by id asc;
select * from student order by id desc;
select * from student group by gender;
select gender ,count(*) from student group by gender having count(*)>2;


SQL语句的分类
DDL:data define language;数据定义语言
create ,dop,alter,
DML: 数据操作语言
insert delete update.truncate table;
DQL:数据查询语言。
select show ;