目录
一、准备工作
1、安装MySQL数据库
2、实验准备,数据表配置
<span style="color:#000000"><span style="background-color:#282c34"><code>mysql -uroot -p
show databases;
create database train_ticket;
use train_ticket;
create table REGION(region varchar(10),site varchar(20));
create table FARE(site varchar(20),money int(10),date varchar(15));
desc REGION;
desc FARE;
insert into REGION values ('south','changsha');
insert into REGION values ('south','nanchang');
insert into REGION values ('north','beijing');
insert into REGION values ('north','tianjin');
insert into FARE values ('changsha',1000,'2021-01-30');
insert into FARE values ('nanchang',700,'2021-01-30');
insert into FARE values ('beijing',1500,'2021-01-30');
insert into FARE values ('tianjin',1200,'2021-01-30');
insert into FARE values ('beijing',2200,'2021-02-05');
select * from REGION;
select * from FARE;
</code></span></span>
二、MySQL 高级(进阶) SQL 语句
1、SELECT
显示表格中一个或数个字段的所有资料
语法:SELECT 字段 FROM 表名
<span style="color:#000000"><span style="background-color:#282c34"><code>select region from REGION;
</code></span></span>
2、DISTINCT
不显示重复的资料(去重)
语法:SELECT DISTINCT 字段 FROM 表名