백엔드개발/데이터베이스
MYSQL DDL 쿼리 CREATE ALTER
HULIA(휴리아)
2018. 12. 16. 21:06
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 ;