2，MySQL基础

创建/删除 数据库
CREATE DATABASE Secbang(数据库的名称）
DROP DATEBASE Secbang

创建/删除 表
CREATE TABLE student(Id int,City varchar(255));
DROP TABLE student;

select 查询表
1,insert into 插入数据
insert into zakes values(2,“名字”)

2,select 查询
select * from student

select 条件查询
1,where
select * from test where names=“hacker”;
2,like
select * from persons where firstname like ‘eorge’
3,%通配符
select * from persons where city like ‘ne%’?>

order by 语句查询字段

1,insert into 插入数据
insert into 表名 values(2,“name”);
2,Select 查询
SELECT * FROM student