Sintaks :

ALTER TABLE [nama_table] ADD [nama column] [type column]

Contoh :

ALTER TABLE tbl_company_bank ADD company_branch char(11) NOT NULL DEFAULT ” AFTER company_code;

Sumber : http://yustian.web.id/website/mysql/perintah-dasar-dalam-database-mysql/