MySQL 批量插入数据：银行信息示例

INSERT INTO table_name(id, bank_name, province, city, city_number, bank_full_name, jones_lang_number, bank_number) VALUES (1, 'ABC Bank', 'Shanghai', 'Shanghai', 310000, 'ABC Bank Shanghai Branch', 10001, 100001), (2, 'ICBC', 'Beijing', 'Beijing', 110000, 'Industrial and Commercial Bank of China Beijing Branch', 10002, 100002), (3, 'CMB', 'Guangdong', 'Shenzhen', 440300, 'China Merchants Bank Shenzhen Branch', 10003, 100003), (4, 'Bank of China', 'Zhejiang', 'Hangzhou', 330100, 'Bank of China Hangzhou Branch', 10004, 100004), (5, 'CCB', 'Guizhou', 'Guiyang', 520100, 'China Construction Bank Guiyang Branch', 10005, 100005), (6, 'BOCOM', 'Jiangsu', 'Nanjing', 320100, 'Bank of Communications Nanjing Branch', 10006, 100006), (7, 'SPDB', 'Shanghai', 'Shanghai', 310000, 'Shanghai Pudong Development Bank Shanghai Branch', 10007, 100007), (8, 'ABC Bank', 'Beijing', 'Beijing', 110000, 'ABC Bank Beijing Branch', 10008, 100008), (9, 'CITIC Bank', 'Shanghai', 'Shanghai', 310000, 'CITIC Bank Shanghai Branch', 10009, 100009), (10, 'CMB', 'Shenzhen', 'Shenzhen', 440300, 'China Merchants Bank Shenzhen Branch', 10010, 100010), ... (继续添加)