Mysql视图创建及删除

1、创建

-- 在supplier_classification_data表上创建一个视图supplier_view
create view supplier_view as select * from supplier_classification_data where is_deleted=0

-- 在supplier_classification_data表上创建一个视图student_views，展示字段自定义id,els_account, supplier_name
create view student_views(id,els_account, supplier_name)
		as 
		SELECT id,els_account, supplier_name FROM supplier_classification_data 

2、删除视图

drop view if exists student_views;