maysql 视图有关问题 请问

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;