How to add a column to a table

ALTER TABLE `cybernet_posterstore`.`categoryinformation` ADD COLUMN `LanguageID` INTEGER NOT NULL DEFAULT 1 AFTER `CategoryNumber`;