Reso | php面试题（mysql基础）

一. 基本的SQL语句

1. 查询

select * from table

2. 更新

update table set field=value

3. 插入

insert [into] table (field) values(value)

4. 删除

delete [from] table

5.关联

6.子查询

SELECT * FROM Scores WHERE SId IN(SELECT Id FROM Students WHERE Class='二班')

---