9.3 视图

/* 语法规则

create view 视图名

AS

合法有效的SQL语句

*/

-- 视图封装   找出id 50-60之间的产品

CREATE VIEW v1

AS

SELECT goods_id,goods_name FROM tp_goods WHERE tp_goods.`goods_id` BETWEEN 50 AND 60;

-- 使用视图

SELECT * FROM v1

-- 存储过程

INSERT INTO boys VALUES(9,'张三',0);

INSERT * FROM boys;

INSERT INTO boys VALUES(13,'李四',1),(14,'王五',12),(15,'张三',0);

DELIMITER $

CREATE PROCEDURE p1()

BEGIN

INSERT INTO boys VALUES(13,'李四',1),

(14,'王五',12),

(15,'张三',0);

END

CALL p1()