ecshop系统的MySQL添加字段

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECt b.brand_id, b.brand_name, b.brand_logo,b.blogo FROM `cobuy`.`ecs_brand`AS b where b.is_show=1 ORDER BY b.sort_order desc ) [2] => Array ( [error] => Unknown column 'b.blogo' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

以上错误 请问要如何添加表字段

添加字段：blogo?还是 brand_blogo?
表：ecs_brand
类型好像是：VARCHAR

请给出整句怎么写
alter table .................................

添加字段的语法：alter table [表名] add [字段名] 字段属性 default 缺省值 default
是可选参数

alter table ecs_brand add blogo varchar(10)

支持一下感觉挺不错的