INSERT INTO ch_provinces (id,province) VALUES ( 1,'北京市'); INSERT INTO ch_provinces (id,province) VALUES ( 2,'天津市'); INSERT INTO ch_provinces (id,province) VALUES ( 3,'河北省'); INSERT INTO ch_provinces (id,province) VALUES ( 4,'山西省'); INSERT INTO ch_provinces (id,province) VALUES ( 5,'内蒙古自治区'); INSERT INTO ch_provinces (id,province) VALUES ( 6,'辽宁省'); INSERT INTO ch_provinces (id,province) VALUES ( 7,'吉林省'); INSERT INTO ch_provinces (id,province) VALUES ( 8,'黑龙江省'); INSERT INTO ch_provinces (id,province) VALUES ( 9,'上海市'); INSERT INTO ch_provinces (id,province) VALUES ( 10,'江苏省'); INSERT INTO ch_provinces (id,province) VALUES ( 11,'浙江省'); INSERT INTO ch_provinces (id,province) VALUES ( 12,'安徽省'); INSERT INTO ch_provinces (id,province) VALUES ( 13,'福建省'); INSERT INTO ch_provinces (id,province) VALUES ( 14,'江西省'); INSERT INTO ch_provinces (id,province) VALUES ( 15,'山东省'); INSERT INTO ch_provinces (id,province) VALUES ( 16,'河南省'); INSERT INTO ch_provinces (id,province) VALUES ( 17,'湖北省'); INSERT INTO ch_provinces (id,province) VALUES ( 18,'湖南省'); INSERT INTO ch_provinces (id,province) VALUES ( 19,'广东省'); INSERT INTO ch_provinces (id,province) VALUES ( 20,'广西壮族自治区'); INSERT INTO ch_provinces (id,province) VALUES ( 21,'海南省'); INSERT INTO ch_provinces (id,province) VALUES ( 22,'重庆市'); INSERT INTO ch_provinces (id,province) VALUES ( 23,'四川省'); INSERT INTO ch_provinces (id,province) VALUES ( 24,'贵州省'); INSERT INTO ch_provinces (id,province) VALUES ( 25,'云南省'); INSERT INTO ch_provinces (id,province) VALUES ( 26,'西藏自治区'); INSERT INTO ch_provinces (id,province) VALUES ( 27,'陕西省'); INSERT INTO ch_provinces (id,province) VALUES ( 28,'甘肃省'); INSERT INTO ch_provinces (id,province) VALUES ( 29,'青海省'); INSERT INTO ch_provinces (id,province) VALUES ( 30,'宁夏回族自治区'); INSERT INTO ch_provinces (id,province) VALUES ( 31,'新疆维吾尔自治区');