MYSQL DDL 쿼리 CREATE ALTER

CREATE TABLE `BANK_SMS_PARSING` (

  `ID` int(11) NOT NULL AUTO_INCREMENT,

  `BANK_NAME` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  `SMS_ADDRESS` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  `DELIMITER` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  `LEN_ACCOUNTNUM` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  `POS_DATE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  `POS_ACCOUNTNUM` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  `POS_PRICE` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `easywhooing`.`CARD_SMS_PARSING` 

CHANGE COLUMN `ID` `ID` INT(11) NOT NULL AUTO_INCREMENT ;