create database db_foo; 建库
show databases; 展示数据库
use db_foo;切换到foo数据库
drop database db_foo;删库
create table tb_student(name char(32),age int,c_name varchar(32));建表
show tables;展示表
select * from tb_student;显示表内容
drop table tb_student;删表
alter table tb_student rename to tb_students;修改表名
desc tb_student;查看表格属性
alter table tb_student change school 学校 varchar(32);修改表的表头
删除
delete from tb_student where name=‘罗源’(age>22);删除name等于罗源(age>22)的。
delete from tb_student where name in(not in) (‘张宇’,‘张凯’);删除name在集合里的。
delete from tb_student where name like ‘%罗%’;删除name里有罗字的。
delete from tb_student where age between 20 and 40;删除age在20~40的。
delete from tb_student where name=‘罗源’(age>22 and(or) name='罗源‘);删除name等于罗源(age>22 且(或)名字等于罗源)的。
delete from tb_student;删全部内容
truncate tb_student;删除全部内容
改
update tb_student set name=‘张宇’;name全部改成张宇。
其他与删除类似
增
insert into tb_student value(‘罗源’, 23,‘文理’);
where
order by (desc)
group by
join叫做连接查询
left join
right join
limit