什么是DQL
- Data Query Language 简称DQL,数据库查询语言, 关键字为SELECT
语法
基本用法
简单查询
准备
- 新建一个考试成绩表,并添加数据
create table exam( id int primary key auto_increment, name varchar(20) not null, chinese double, math double, english double ); insert into exam values(null,'关羽',85,76,70); insert into exam values(null,'张飞',70,75,70); insert into exam values(null,'赵云',90,65,95); insert into exam values(null,'刘备',null,55,38);