maysql 视图问题 请教
create view company_info(name,state)as
select * from company;

company 表有 name adress city state 四个属性 为什么在 mysql5.0里面建立不了这样的视图呢？？？？

[解决办法]
create view company_info(name,state)as
select name,state from company;

[解决办法]
create view company_info(name,state)as
select name,state from company;