table 생성,컬럼 추가 등등..

CREATE TABLE `table`(    
  id INT(11) NOT NULL AUTO_INCREMENT, 
  target VARCHAR(20) NOT NULL  DEFAULT 'individual',     
)

ALTER TABLE `table` ADD target VARCHAR(20) ;

ALTER TABLE `table` ADD target VARCHAR(20) NOT NULL DEFAULT 'individual' AFTER `name`  ;

ALTER TABLE `table` 
CHANGE COLUMN `target` `target` VARCHAR(20) NOT NULL ;

ALTER TABLE `table`  MODIFY `target` VARCHAR(20) NOT NULL;