DQL(数据查询语言)(简单的)
DQL:Data Query Language
作用:查询数据
常用关键字:SELECT
创建一个学生表
create table stu
(
id int,
name varchar(30),
sex char(2),
age int,
address varchar(50)
);
insert into stu values(1,'张无忌','男',20,'北京');
insert into stu values(2,'小龙女','女',18,'古墓');
insert into stu values(3,'黄蓉','女',15,'桃花岛');
insert into stu values(4,'韦小宝','男',24,'扬州');
insert into stu values(5,'乔峰','男',34,'雁门关');
insert into stu values(6,'张果老','男',34,'雁门关');
insert into stu values(7,'老张','男',38,'黑木崖');
insert into stu values(8,'黄药师','男',34,'桃花岛');