[MYSQL] 국내 은행 리스트
CREATE TABLE IF NOT EXISTS `t_banklist` ( `idx` int(11) NOT NULL AUTO_INCREMENT, `bank_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`idx`), KEY `bank_name` (`bank_name`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='은행리스트(국내)'; INSERT INTO `t_banklist` (`idx`, `bank_name`) VALUES (1, 'SC제일은행'), (2, '경남은행'), (3, '광주은행'), (4, '국민은행'), (5, '굿모닝신한증권'), (6, '농협중앙회'), (7, '농협..
2023. 3. 9.
[MYSQL] 전체 국가 데이터 모음
CREATE TABLE IF NOT EXISTS `g5_nation` ( `idx` int(11) NOT NULL AUTO_INCREMENT, `nation` varchar(255) NOT NULL, `alpha_2` varchar(255) NOT NULL, `alpha_3` varchar(255) NOT NULL, PRIMARY KEY (`idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `g5_nation` (`idx`, `nation`, `alpha_2`, `alpha_3`) VALUES (1, '가나', 'GH', 'GHA'), (2, '가봉', 'GA', 'GAB'), (3, '가이아나', 'GY', 'GUY'), (4, '감비아', 'GM', ..
2023. 3. 8.