mysql 视图

2014年2月14日 15:27:13

The view definition is “frozen” at creation time, so changes to the underlying tables afterward do not affect the view definition. For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view

视图的结构不会主动动态变化,如果创建试图时使用的是 select * from a; 如果随后表 a 添加了一些字段,那么,视图是不会自动添加这些字段的