1,create view v_customerasselect First_Name, Last_Name, Countryfrom customer2.drop view v_customer3.所谓的视图并不是真正存在的表,而是一条sql语句而已,想要增加字段只要重新建立一下视图就可以了