MySQL - 05.视图、存储过程和函数、流程控制结构

1. 视图

2. 存储过程和函数

2.1 存储过程

2.2 函数

3. 流程控制结构

3.1 分支结构

3.2 循环结构

#视图

#创建视图
CREATE VIEW world.SOMECOUNTRYINFO
AS
SELECT world.country.`Name`,world.country.Population
FROM world.country
WHERE world.country.Population>10000000
ORDER BY world.country.Population DESC;

SELECT *
FROM SOMECOUNTRYINFO;

#修改视图
ALTER VIEW SOMECOUNTRYINFO
AS
SELECT 

#删除视图
DROP VIEW world.SOMECOUNTRYINFO;

#通用写法
CREATE OR REPLACE VIEW SOMECOUNTRYINFO
AS

#更新视图
INSERT INTO world.somecountryinfo
VALUES("AC",123456789);

UPDATE world.somecountryinfo
SET world.somecountryinfo.Population=987654321
WHERE world.somecountryinfo.`Name`="AC";

DELETE FROM world.somecountryinfo
WHERE world.somecountryinfo.`Name`="AC";

SELECT *
FROM world.somecountryinfo;