FormatSQL/out.sql at master · dolphinsboy/FormatSQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
INSERT INTO `wk_adsense`.`wk_cct_extend_area` (`business_type`, `province_id`, `city_id`, `remark`, `create_time`
	, `tencent_id`)
VALUES (290, 101, 101001, '北京', unix_timestamp(now())
		, 110100),
	(290, 102, 102001, '天津', unix_timestamp(now())
		, 120100),
	(290, 105, 105001, '石家庄', unix_timestamp(now())
		, 130100),
	(290, 105, 105005, '唐山', unix_timestamp(now())
		, 130200),
	(290, 105, 105011, '邯郸', unix_timestamp(now())
		, 130400),
	(290, 105, 105006, '廊坊', unix_timestamp(now())
		, 131000),
	(290, 106, 106001, '太原', unix_timestamp(now())
		, 140100),
	(290, 106, 106004, '阳泉', unix_timestamp(now())
		, 140300),
	(290, 107, 107001, '呼和浩特', unix_timestamp(now())
		, 150100),
	(290, 107, 107002, '包头', unix_timestamp(now())
		, 150200),
	(290, 107, 107007, '鄂尔多斯', unix_timestamp(now())
		, 150600),
	(290, 108, 108001, '沈阳', unix_timestamp(now())
		, 210100),
	(290, 108, 108010, '大连', unix_timestamp(now())
		, 210200),
	(290, 108, 108008, '鞍山', unix_timestamp(now())
		, 210300),
	(290, 108, 108009, '丹东', unix_timestamp(now())
		, 210600),
	(290, 108, 108013, '锦州', unix_timestamp(now())
		, 210700),
	(290, 108, 108011, '营口', unix_timestamp(now())
		, 210800),
	(290, 109, 109001, '长春', unix_timestamp(now())
		, 220100),
	(290, 109, 109004, '吉林', unix_timestamp(now())
		, 220200),
	(290, 110, 110001, '哈尔滨', unix_timestamp(now())
		, 230100),
	(290, 110, 110005, '大庆', unix_timestamp(now())
		, 230600),
	(290, 103, 103001, '上海', unix_timestamp(now())
		, 310100),
	(290, 111, 111001, '南京', unix_timestamp(now())
		, 320100),
	(290, 111, 111012, '无锡', unix_timestamp(now())
		, 320200),
	(290, 111, 111011, '常州', unix_timestamp(now())
		, 320400),
	(290, 111, 111013, '苏州', unix_timestamp(now())
		, 320500),
	(290, 111, 111009, '南通', unix_timestamp(now())
		, 320600),
	(290, 111, 111007, '扬州', unix_timestamp(now())
		, 321000),
	(290, 112, 112001, '杭州', unix_timestamp(now())
		, 330100),
	(290, 112, 112005, '宁波', unix_timestamp(now())
		, 330200),
	(290, 112, 112010, '温州', unix_timestamp(now())
		, 330300),
	(290, 112, 112003, '嘉兴', unix_timestamp(now())
		, 330400),
	(290, 112, 112002, '湖州', unix_timestamp(now())
		, 330500),
	(290, 112, 112006, '绍兴', unix_timestamp(now())
		, 330600),
	(290, 112, 112008, '金华', unix_timestamp(now())
		, 330700),
	(290, 112, 112009, '台州', unix_timestamp(now())
		, 331000),
	(290, 113, 113001, '合肥', unix_timestamp(now())
		, 340100),
	(290, 113, 113010, '芜湖', unix_timestamp(now())
		, 340200),
	(290, 113, 113006, '蚌埠', unix_timestamp(now())
		, 340300),
	(290, 113, 113009, '马鞍山', unix_timestamp(now())
		, 340500),
	(290, 113, 113016, '池州', unix_timestamp(now())
		, 341700),
	(290, 114, 114001, '福州', unix_timestamp(now())
		, 350100),
	(290, 114, 114006, '厦门', unix_timestamp(now())
		, 350200),
	(290, 114, 114005, '泉州', unix_timestamp(now())
		, 350500),
	(290, 114, 114007, '漳州', unix_timestamp(now())
		, 350600),
	(290, 114, 114008, '龙岩', unix_timestamp(now())
		, 350800),
	(290, 115, 115001, '南昌', unix_timestamp(now())
		, 360100),
	(290, 116, 116001, '济南', unix_timestamp(now())
		, 370100),
	(290, 116, 116002, '青岛', unix_timestamp(now())
		, 370200),
	(290, 116, 116006, '淄博', unix_timestamp(now())
		, 370300),
	(290, 116, 116005, '东营', unix_timestamp(now())
		, 370500),
	(290, 116, 116008, '烟台', unix_timestamp(now())
		, 370600),
	(290, 117, 117001, '郑州', unix_timestamp(now())
		, 410100),
	(290, 117, 117004, '洛阳', unix_timestamp(now())
		, 410300),
	(290, 117, 117005, '焦作', unix_timestamp(now())
		, 410800),
	(290, 117, 117011, '许昌', unix_timestamp(now())
		, 411000),
	(290, 117, 117014, '南阳', unix_timestamp(now())
		, 411300),
	(290, 118, 118001, '武汉', unix_timestamp(now())
		, 420100),
	(290, 119, 119001, '长沙', unix_timestamp(now())
		, 430100),
	(290, 119, 119006, '株洲', unix_timestamp(now())
		, 430200),
	(290, 119, 119007, '湘潭', unix_timestamp(now())
		, 430300),
	(290, 119, 119008, '衡阳', unix_timestamp(now())
		, 430400),
	(290, 119, 119009, '郴州', unix_timestamp(now())
		, 431000),
	(290, 120, 120001, '广州', unix_timestamp(now())
		, 440100),
	(290, 120, 120002, '深圳', unix_timestamp(now())
		, 440300),
	(290, 120, 120013, '珠海', unix_timestamp(now())
		, 440400),
	(290, 120, 120008, '汕头', unix_timestamp(now())
		, 440500),
	(290, 120, 120016, '佛山', unix_timestamp(now())
		, 440600),
	(290, 120, 120015, '江门', unix_timestamp(now())
		, 440700),
	(290, 120, 120011, '惠州', unix_timestamp(now())
		, 441300),
	(290, 120, 120012, '东莞', unix_timestamp(now())
		, 441900),
	(290, 120, 120014, '中山', unix_timestamp(now())
		, 442000),
	(290, 121, 121001, '南宁', unix_timestamp(now())
		, 450100),
	(290, 121, 121003, '柳州', unix_timestamp(now())
		, 450200),
	(290, 121, 121002, '桂林', unix_timestamp(now())
		, 450300),
	(290, 122, 122001, '海口', unix_timestamp(now())
		, 460100),
	(290, 122, 122002, '三亚', unix_timestamp(now())
		, 460200),
	(290, 104, 104001, '重庆', unix_timestamp(now())
		, 500100),
	(290, 123, 123001, '成都', unix_timestamp(now())
		, 510100),
	(290, 123, 123003, '绵阳', unix_timestamp(now())
		, 510700),
	(290, 124, 124001, '贵阳', unix_timestamp(now())
		, 520100),
	(290, 125, 125001, '昆明', unix_timestamp(now())
		, 530100),
	(290, 125, 125002, '曲靖', unix_timestamp(now())
		, 530300),
	(290, 127, 127001, '西安', unix_timestamp(now())
		, 610100),
	(290, 127, 127006, '宝鸡', unix_timestamp(now())
		, 610300),
	(290, 127, 127008, '榆林', unix_timestamp(now())
		, 610800),
	(290, 128, 128001, '兰州', unix_timestamp(now())
		, 620100),
	(290, 131, 131001, '乌鲁木齐', unix_timestamp(now())
		, 650100);