How to edit a table and add a column

MySQL ===== ALTER TABLE `smsdb`.`kb` ADD COLUMN `createdBy` TEXT NOT NULL AFTER `productCategoryId`;