-最常用8个核心语句
-练习
-8个核心语句背后的执行逻辑
SQL核心语句组成:
① select 列名/聚合函数 as 别名 (select必选,as可选)
② from 表名(必选)
③ where 限制条件(可选)
④ group by 列名(可选)
⑤ having 限制条件(可选)
⑥ order by 列名 asc/desc(可选)
⑦ limit 行数(可选)
SQL查询执行顺序:2345167
-案例问题:在指定的数据库中创建表并插入数据
-建表:
create table MysqlTest.content(
content_id int(11),
user_id int(11),
create_date date,
type text(10)
)
-插入数据:
insert into MysqlTest.content valus
(1345285694,46372583,'2018-12-01','post'),
(1345285695,47378323,'2018-12-06','comment'),
(1345285696,53647584,'2018-12-10','vedio'),
(1345285697,47583920,'2018-12-11','post'),
(1345285698,54789392,'2018-12-05','comment'),
(1345285699,53647583,'2018-12-07','vedio'),
(1345285700,47381933,'2018-12-10','post'),
-调取所有的id:
select content_id from MysqlTest.conten