SQL 比较全的银行列表、带名称缩写、带银行logo | 您所在的位置:网站首页 › 中国银行所有名称查询电话 › SQL 比较全的银行列表、带名称缩写、带银行logo |
银行图标我已帮助整理可直接复制使用,数据库在最下面。 银行名称缩写logo招商银行CMB![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() logo资源下载链接 https://download.csdn.net/download/qq_24909089/10725871 附赠mysql: DROP TABLE IF EXISTS `bank`; CREATE TABLE `bank` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bank_name` varchar(20) NOT NULL COMMENT '银行名称', `bank_code` varchar(11) NOT NULL COMMENT '银行标识码', PRIMARY KEY (`id`), KEY `bank_name` (`bank_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; LOCK TABLES `bank` WRITE; INSERT INTO `bank` (`id`, `bank_name`, `bank_code`) VALUES(2,'招商银行','CMB'), (3,'建设银行','CCB'), (4,'交通银行','BOCOM'), (5,'邮储银行','PSBC'), (6,'工商银行','ICBC'), (7,'农业银行','ABC'), (8,'中国银行','BOC'), (9,'中信银行','CITIC'), (10,'光大银行','CEB'), (11,'华夏银行',' HXB'), (12,'民生银行','CMSB'), (13,'广发银行','CGB'), (14,'平安银行','SZD'), (15,'星展银行','DBS'), (16,'恒生银行','HSBC'), (17,'渣打银行','SCBFF'), (18,'汇丰银行','HSBC'), (19,'东亚银行','HKBEA'), (20,'花旗银行',''), (21,'浙商银行','CZB'), (22,'恒丰银行','HFB'), (23,'浦东发展银行','SPDB'), (24,'兴业银行','CIB'), (26,'齐鲁银行','QLB'), (27,'烟台银行','YTB'), (28,'淮坊银行','WFB'), (31,'渤海银行',''), (32,'上海银行','BOS'), (33,'厦门银行',''), (34,'北京银行','BCCB'), (35,'福建海峡银行',''), (36,'吉林银行',''), (38,'宁波银行','NBCB'), (39,'焦作市商业银行',''), (40,'温州银行',''), (41,'广州银行',''), (42,'汉口银行',''), (43,'龙江银行',''), (44,'盛京银行',''), (45,'洛阳银行',''), (46,'辽阳银行',''), (47,'大连银行','BODL'), (48,'苏州银行',''), (49,'河北银行',''), (50,'杭州银行','HCCB'), (51,'南京银行',''), (52,'东莞银行',''), (53,'金华银行',''), (54,'乌鲁木齐商业银行',''), (55,'绍兴银行',''), (56,'成都银行',''), (57,'抚顺银行',''), (58,'临商银行',''), (59,'宜昌市商业银行',''), (60,'葫芦岛银行',''), (61,'郑州银行',''), (62,'宁夏银行',''), (63,'珠海华润银行',''), (64,'齐商银行',''), (65,'锦州银行',''), (66,'徽商银行',''), (67,'重庆银行',''), (68,'哈尔滨银行',''), (69,'贵阳银行',''), (70,'西安银行',''), (71,'无锡市商业银行',''), (72,'丹东银行',''), (73,'兰州银行',''), (74,'南昌银行',''), (75,'晋商银行',''), (76,'青岛银行',''), (77,'南通商业银行',''), (78,'九江银行',''), (79,'日照银行',''), (80,'鞍山银行',''), (81,'秦皇岛银行',''), (82,'青海银行',''), (83,'台州银行',''), (84,'盐城银行',''), (85,'长沙银行',''), (86,'赣州银行',''), (87,'泉州银行',''), (88,'营口银行',''), (89,'富滇银行',''), (90,'阜新银行',''), (91,'嘉兴银行',''), (92,'廊坊银行',''), (93,'泰隆商业银行',''), (94,'内蒙古银行',''), (95,'湖州银行',''), (96,'沧州银行',''), (97,'广西北部湾银行',''), (98,'包商银行',''), (100,'威海商业银行',''), (101,'攀枝花市商业银行',''), (102,'绵阳市商业银行',''), (103,'泸州市商业银行',''), (104,'三门峡银行',''), (106,'邢台银行','XTB'), (107,'商丘市商业银行',''), (108,'安徽省农村信用社','AHNSYH'), (109,'江西省农村信用社',''), (110,'湖南农村信用社',''), (111,'无锡农村商业银行','');很多银行没有明确的缩写所以留空了,如有明确的缩写请留言,全程手打,如有问题或错误请自行修改。
|
CopyRight 2018-2019 实验室设备网 版权所有 |