【MySQL】三天复习MySQL（一）

分手后的思念是犯贱 2022-12-11 02:22 195阅读 0赞

最近找工作被疯狂吊打，很多东西要重新复习，MySQL就是其中之一，常出的MySQL编程题不会很难，但你总得记住基本的sql语句，以前我写过一篇  
，今天写些更简单详细的，废话少说，上代码：

**建库，删库**

create database mydb default character set ='utf8'; --建库基本命令
    --databasename 根据需求修改
    drop database name;
    --删库

**建表**

create table student(
     id int(10) not null,
     phone_num varchar(11) default null,
     address varchar(255) default null,
     price float default null,
     type tinyint(2)default null,
     create_time datetime default null,
     primary key(id)
    )engine =InnoDB default charset=utf8;

**删表**

drop table student;

**插入**

insert into student(phone_num,address,price,type,create_time)values(13333333333,'北京',88.8,1,now());

**批量插入**

insert into student(phone_num,address,price,type,create_time)values
    (13333333333,'北京',88.8,1,now()),(13333333333,'北京',88.8,1,now()),(13333333333,'北京',88.8,1,now()),(13333333333,'北京',88.8,1,now());

**查询**

select _____,_____,______ from student where ____ =____;

**更新**

update  _____ set 修改内容 where ____;

**删除**

delete from student;--删除所有数据
    --条件查询
    delete _____ from student where ____ =____;

**模糊查询**  
当你知道某信息的一部分数据想要进行查询时就可使用通配符%模糊查询  
例如，知道某手机号的一部分：

select * from student where phone_num like '%1234';--知道后面
    select * from student where phone_num like '12%34';--知道两边
    select * from student where phone_num like '1234%';--知道前面

**范围查询**

select * from student where  price between ____ and _____;
    select * from student where price in();
    select * from student where price in(3,8,4);--三挑一
    select * from student where price not in();
    select * from student where price > ____;
    select * from student where price < ____;