필드 크기는 알아서 조절하세요

CREATE TABLE `backinfo` (

  `bankno` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '은행코드',

  `banknm` varchar(30) NOT NULL COMMENT '은행명',

  `bankkind` varchar(30) DEFAULT NULL COMMENT '구분',

  `banktype` tinyint(1) NOT NULL COMMENT '타입',

  PRIMARY KEY (`bankno`),

  UNIQUE KEY `upxbanknm` (`banknm`)

);

insert  into `backinfo`(`bankno`,`banknm`,`bankkind`,`banktype`) values (1,'HK상호저축은행','상호저축은행',6),(2,'HMC투자증권','금융투자회사',9),(3,'IBK투자증권','금융투자회사',9),(4,'IM투자증권','금융투자회사',9),(5,'KB국민은행','주요은행',1),(6,'KDB대우증권','금융투자회사',9),(7,'LIG투자증권','금융투자회사',9),(8,'NH농협은행','국책은행',3),(9,'NH농협증권','금융투자회사',9),(10,'S&T상호저축은행','상호저축은행',6),(11,'SBI상호저축은행','상호저축은행',6),(12,'SC스탠다드상호저축은행','상호저축은행',6),(13,'SK증권','금융투자회사',9),(14,'강원상호저축은행','상호저축은행',6),(15,'경기상호저축은행','상호저축은행',6),(16,'경남은행','지방은행',2),(17,'경남제일상호저축은행','상호저축은행',6),(18,'경은상호저축은행','상호저축은행',6),(19,'고려상호저축은행','상호저축은행',6),(20,'광주은행','지방은행',2),(21,'교보증권','금융투자회사',9),(22,'교원나라상호저축은행','상호저축은행',6),(23,'구미상호저축은행','상호저축은행',6),(24,'국제상호저축은행','상호저축은행',6),(25,'금화상호저축은행','상호저축은행',6),(26,'남양상호저축은행','상호저축은행',6),(27,'농축협','상호금융기관',4),(28,'늘푸른상호저축은행','상호저축은행',6),(29,'대구은행','지방은행',2),(30,'대명상호저축은행','상호저축은행',6),(31,'대백상호저축은행','상호저축은행',6),(32,'대성상호저축은행','상호저축은행',6),(33,'대송상호저축은행','상호저축은행',6),(34,'대신증권','금융투자회사',9),(35,'대아상호저축은행','상호저축은행',6),(36,'대영상호저축은행','상호저축은행',6),(37,'대원상호저축은행','상호저축은행',6),(38,'대진상호저축은행','상호저축은행',6),(39,'대한상호저축은행','상호저축은행',6),(40,'도민상호저축은행','상호저축은행',6),(41,'동광상호저축은행','상호저축은행',6),(42,'동부상호저축은행','상호저축은행',6),(43,'동부증권','금융투자회사',9),(44,'동양상호저축은행','상호저축은행',6),(45,'동양증권','금융투자회사',9),(46,'메리츠종합금융증권','금융투자회사',9),(47,'무등상호저축은행','상호저축은행',6),(48,'미래상호저축은행','상호저축은행',6),(49,'미래에셋증권','금융투자회사',9),(50,'미래창조과학부','비은행금융기관',10),(51,'민국상호저축은행','상호저축은행',6),(52,'밀양상호저축은행','상호저축은행',6),(53,'보해상호저축은행','상호저축은행',6),(54,'부국증권','금융투자회사',9),(55,'부림상호저축은행','상호저축은행',6),(56,'부민상호저축은행','상호저축은행',6),(57,'부산2상호저축은행','상호저축은행',6),(58,'부산상호저축은행','상호저축은행',6),(59,'부산솔로몬상호저축은행','상호저축은행',6),(60,'부산은행','지방은행',2),(61,'분당상호저축은행','상호저축은행',6),(62,'산림조합','상호금융기관',4),(63,'삼보상호저축은행','상호저축은행',6),(64,'삼성상호저축은행','상호저축은행',6),(65,'삼성증권','금융투자회사',9),(66,'삼신상호저축은행','상호저축은행',6),(67,'삼일상호저축은행','상호저축은행',6),(68,'삼정상호저축은행','상호저축은행',6),(69,'삼화두리상호저축은행','상호저축은행',6),(70,'삼화상호저축은행','상호저축은행',6),(71,'상업상호저축은행','상호저축은행',6),(72,'새누리상호저축은행','상호저축은행',6),(73,'새마을금고','서민금융기관',5),(74,'서울상호저축은행','상호저축은행',6),(75,'서일상호저축은행','상호저축은행',6),(76,'세람상호저축은행','상호저축은행',6),(77,'센트럴상호저축은행','상호저축은행',6),(78,'솔로몬상호저축은행','상호저축은행',6),(79,'수협중앙회','국책은행',3),(80,'스카이상호저축은행','상호저축은행',6),(81,'스타상호저축은행','상호저축은행',6),(82,'신라상호저축은행','상호저축은행',6),(83,'신안상호저축은행','상호저축은행',6),(84,'신영증권','금융투자회사',9),(85,'신용협동조합','서민금융기관',5),(86,'신한금융투자','금융투자회사',9),(87,'신한은행','주요은행',1),(88,'아산상호저축은행','상호저축은행',6),(89,'아주상호저축은행','상호저축은행',6),(90,'안국상호저축은행','상호저축은행',6),(91,'안양상호저축은행','상호저축은행',6),(92,'에이스상호저축은행','상호저축은행',6),(93,'엠에스상호저축은행','상호저축은행',6),(94,'영진상호저축은행','상호저축은행',6),(95,'영풍상호저축은행','상호저축은행',6),(96,'예가람상호저축은행','상호저축은행',6),(97,'예한울상호저축은행','상호저축은행',6),(98,'오성상호저축은행','상호저축은행',6),(99,'외환은행','주요은행',1),(100,'우리상호저축은행','상호저축은행',6),(101,'우리은행','주요은행',1),(102,'우리투자증권','금융투자회사',9),(103,'유니온상호저축은행','상호저축은행',6),(104,'유진투자증권','금융투자회사',9),(105,'융창상호저축은행','상호저축은행',6),(106,'으뜸상호저축은행','상호저축은행',6),(107,'이트레이드증권','금융투자회사',9),(108,'인성상호저축은행','상호저축은행',6),(109,'인천상호저축은행','상호저축은행',6),(110,'전북상호저축은행','상호저축은행',6),(111,'전북은행','지방은행',2),(112,'전일상호저축은행','상호저축은행',6),(113,'제이원상호저축은행','상호저축은행',6),(114,'제일상호저축은행','상호저축은행',6),(115,'제주은행','지방은행',2),(116,'조흥상호저축은행','상호저축은행',6),(117,'중부상호저축은행','상호저축은행',6),(118,'중소기업은행','국책은행',3),(119,'중앙부산상호저축은행','상호저축은행',6),(120,'진주상호저축은행','상호저축은행',6),(121,'진흥상호저축은행','상호저축은행',6),(122,'창업상호저축은행','상호저축은행',6),(123,'천안상호저축은행','상호저축은행',6),(124,'청주상호저축은행','상호저축은행',6),(125,'키움증권','금융투자회사',9),(126,'토마토상호저축은행','상호저축은행',6),(127,'파라다이스상호저축은행','상호저축은행',6),(128,'파랑새상호저축은행','상호저축은행',6),(129,'평택상호저축은행','상호저축은행',6),(130,'푸른2상호저축은행','상호저축은행',6),(131,'푸른상호저축은행','상호저축은행',6),(132,'프라임상호저축은행','상호저축은행',6),(133,'플러스상호저축은행','상호저축은행',6),(134,'하나대투증권','금융투자회사',9),(135,'하나은행','주요은행',1),(136,'하이투자증권','금융투자회사',9),(137,'한국산업은행','국책은행',3),(138,'한국상호저축은행','상호저축은행',6),(139,'한국수출입은행','국책은행',3),(140,'한국은행','중앙은행',10),(141,'한국투자상호저축은행','상호저축은행',6),(142,'한국투자증권','금융투자회사',9),(143,'한서상호저축은행','상호저축은행',6),(144,'한성상호저축은행','상호저축은행',6),(145,'한신상호저축은행','상호저축은행',6),(146,'한일상호저축은행','상호저축은행',6),(147,'한주상호저축은행','상호저축은행',6),(148,'한중상호저축은행','상호저축은행',6),(149,'한화투자증권','금융투자회사',9),(150,'현대상호저축은행','상호저축은행',6),(151,'현대증권','금융투자회사',9),(152,'호남솔로몬상호저축은행','상호저축은행',6),(153,'화승상호저축은행','상호저축은행',6),(154,'회원수협','상호금융기관',4),(155,'흥국상호저축은행','상호저축은행',6),(157,'노바스코샤은행','외국계은행',8),(158,'도이체방크','외국계은행',8),(159,'모건스탠리은행','외국계은행',8),(160,'미즈호코퍼레이트은행','외국계은행',8),(161,'미쓰비시도쿄UFJ은행','외국계은행',8),(162,'바클레이즈은행','외국계은행',8),(163,'뱅크오브아메리카','외국계은행',8),(164,'소시에테제네랄','외국계은행',8),(165,'중국은행','외국계은행',8),(166,'중국공상은행','외국계은행',8),(167,'호주뉴질랜드은행','외국계은행',8),(168,'ABN암로은행','외국계은행',8),(169,'BNP파리바','외국계은행',8),(170,'DBS은행','외국계은행',8),(171,'HSBC은행','외국계은행',8),(172,'JP모간체이스','외국계은행',8),(173,'UBS은행','외국계은행',8),(174,'한국스탠다드차타드은행','외국계은행',8),(175,'한국씨티은행 ','외국계은행',8);