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;