mysql创建视图

CREATE TABLE customers(
cust_id int  NOT NULL AUTO_INCREMENT,
cust_name CHAR(50) NOT NULL ,
cust_sex CHAR(1) NOT NULL,
cust_address CHAR(50) NULL,
cust_contact CHAR(50) NULL,
PRIMARY KEY(cust_id)
);

insert INTO mysql_test.customers
VALUES(902,‘李四‘,‘M‘,‘武汉‘,‘江夏‘);

insert INTO mysql_test.customers
VALUES(903,‘王五‘,‘F‘,‘杭州‘,‘西湖‘);

select * from mysql_test.customers

use mysql_test
/**
创建视图
*/
create view mysql_test.customers_view
as 
select * from mysql_test.customers
where cust_sex = ‘m‘ with check option;

/**
显示视图
*/
show create view mysql_test.customers_view;


/**
修改视图
*/

alter view mysql_test.customers_view
as 
select * from mysql_test.customers
where cust_sex = ‘f‘ with check option;

/**
向视图中插入数据
*/
insert into mysql_test.customers_view
values (909,‘周明‘,‘f‘,‘武汉‘,‘洪山区‘)

update mysql_test.customers_view
set cust_address = ‘上海市‘

delete  from mysql_test.customers_view where cust_name = ‘周明‘