[MYSQL] 국내 은행 리스트

bank_list_sql.zip

0.00MB

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, '농협회원조합'),
	(8, '대구은행'),
	(9, '대신증권'),
	(10, '대우증권'),
	(11, '동부증권'),
	(12, '동양종합금융증권'),
	(13, '메리츠증권'),
	(14, '미래에셋증권'),
	(15, '뱅크오브아메리카(BOA)'),
	(16, '부국증권'),
	(17, '부산은행'),
	(18, '산림조합중앙회'),
	(19, '산업은행'),
	(20, '삼성증권'),
	(21, '상호신용금고'),
	(22, '새마을금고'),
	(23, '수출입은행'),
	(24, '수협중앙회'),
	(25, '신영증권'),
	(26, '신한은행'),
	(27, '신협중앙회'),
	(28, '에스케이증권'),
	(29, '에이치엠씨투자증권'),
	(30, '엔에이치투자증권'),
	(31, '엘아이지투자증권'),
	(32, '외환은행'),
	(33, '우리은행'),
	(34, '우리투자증권'),
	(35, '우체국'),
	(36, '유진투자증권'),
	(37, '전북은행'),
	(38, '제주은행'),
	(49, '카카오뱅크'),
	(48, '케이뱅크'),
	(39, '키움증권'),
	(40, '하나대투증권'),
	(41, '하나은행'),
	(42, '하이투자증권'),
	(43, '한국씨티은행'),
	(44, '한국투자증권'),
	(45, '한화증권'),
	(46, '현대증권'),
	(47, '홍콩상하이은행');