Skip to content

Instantly share code, notes, and snippets.

@rathboma
Created September 2, 2020 02:04
Show Gist options
  • Save rathboma/4e80a940aff025f8049654d31d507107 to your computer and use it in GitHub Desktop.
Save rathboma/4e80a940aff025f8049654d31d507107 to your computer and use it in GitHub Desktop.
Big ass table with 500 columns
CREATE TABLE `big_ass_table2` (
`foo` INT default 100,
bar0 int default 000,
bar1 int default 100,
bar2 int default 200,
bar3 int default 300,
bar4 int default 400,
bar5 int default 500,
bar6 int default 600,
bar7 int default 700,
bar8 int default 800,
bar9 int default 900,
bar10 int default 1000,
bar11 int default 1100,
bar12 int default 1200,
bar13 int default 1300,
bar14 int default 1400,
bar15 int default 1500,
bar16 int default 1600,
bar17 int default 1700,
bar18 int default 1800,
bar19 int default 1900,
bar20 int default 2000,
bar21 int default 2100,
bar22 int default 2200,
bar23 int default 2300,
bar24 int default 2400,
bar25 int default 2500,
bar26 int default 2600,
bar27 int default 2700,
bar28 int default 2800,
bar29 int default 2900,
bar30 int default 3000,
bar31 int default 3100,
bar32 int default 3200,
bar33 int default 3300,
bar34 int default 3400,
bar35 int default 3500,
bar36 int default 3600,
bar37 int default 3700,
bar38 int default 3800,
bar39 int default 3900,
bar40 int default 4000,
bar41 int default 4100,
bar42 int default 4200,
bar43 int default 4300,
bar44 int default 4400,
bar45 int default 4500,
bar46 int default 4600,
bar47 int default 4700,
bar48 int default 4800,
bar49 int default 4900,
bar50 int default 5000,
bar51 int default 5100,
bar52 int default 5200,
bar53 int default 5300,
bar54 int default 5400,
bar55 int default 5500,
bar56 int default 5600,
bar57 int default 5700,
bar58 int default 5800,
bar59 int default 5900,
bar60 int default 6000,
bar61 int default 6100,
bar62 int default 6200,
bar63 int default 6300,
bar64 int default 6400,
bar65 int default 6500,
bar66 int default 6600,
bar67 int default 6700,
bar68 int default 6800,
bar69 int default 6900,
bar70 int default 7000,
bar71 int default 7100,
bar72 int default 7200,
bar73 int default 7300,
bar74 int default 7400,
bar75 int default 7500,
bar76 int default 7600,
bar77 int default 7700,
bar78 int default 7800,
bar79 int default 7900,
bar80 int default 8000,
bar81 int default 8100,
bar82 int default 8200,
bar83 int default 8300,
bar84 int default 8400,
bar85 int default 8500,
bar86 int default 8600,
bar87 int default 8700,
bar88 int default 8800,
bar89 int default 8900,
bar90 int default 9000,
bar91 int default 9100,
bar92 int default 9200,
bar93 int default 9300,
bar94 int default 9400,
bar95 int default 9500,
bar96 int default 9600,
bar97 int default 9700,
bar98 int default 9800,
bar99 int default 9900,
bar100 int default 10000,
bar101 int default 10100,
bar102 int default 10200,
bar103 int default 10300,
bar104 int default 10400,
bar105 int default 10500,
bar106 int default 10600,
bar107 int default 10700,
bar108 int default 10800,
bar109 int default 10900,
bar110 int default 11000,
bar111 int default 11100,
bar112 int default 11200,
bar113 int default 11300,
bar114 int default 11400,
bar115 int default 11500,
bar116 int default 11600,
bar117 int default 11700,
bar118 int default 11800,
bar119 int default 11900,
bar120 int default 12000,
bar121 int default 12100,
bar122 int default 12200,
bar123 int default 12300,
bar124 int default 12400,
bar125 int default 12500,
bar126 int default 12600,
bar127 int default 12700,
bar128 int default 12800,
bar129 int default 12900,
bar130 int default 13000,
bar131 int default 13100,
bar132 int default 13200,
bar133 int default 13300,
bar134 int default 13400,
bar135 int default 13500,
bar136 int default 13600,
bar137 int default 13700,
bar138 int default 13800,
bar139 int default 13900,
bar140 int default 14000,
bar141 int default 14100,
bar142 int default 14200,
bar143 int default 14300,
bar144 int default 14400,
bar145 int default 14500,
bar146 int default 14600,
bar147 int default 14700,
bar148 int default 14800,
bar149 int default 14900,
bar150 int default 15000,
bar151 int default 15100,
bar152 int default 15200,
bar153 int default 15300,
bar154 int default 15400,
bar155 int default 15500,
bar156 int default 15600,
bar157 int default 15700,
bar158 int default 15800,
bar159 int default 15900,
bar160 int default 16000,
bar161 int default 16100,
bar162 int default 16200,
bar163 int default 16300,
bar164 int default 16400,
bar165 int default 16500,
bar166 int default 16600,
bar167 int default 16700,
bar168 int default 16800,
bar169 int default 16900,
bar170 int default 17000,
bar171 int default 17100,
bar172 int default 17200,
bar173 int default 17300,
bar174 int default 17400,
bar175 int default 17500,
bar176 int default 17600,
bar177 int default 17700,
bar178 int default 17800,
bar179 int default 17900,
bar180 int default 18000,
bar181 int default 18100,
bar182 int default 18200,
bar183 int default 18300,
bar184 int default 18400,
bar185 int default 18500,
bar186 int default 18600,
bar187 int default 18700,
bar188 int default 18800,
bar189 int default 18900,
bar190 int default 19000,
bar191 int default 19100,
bar192 int default 19200,
bar193 int default 19300,
bar194 int default 19400,
bar195 int default 19500,
bar196 int default 19600,
bar197 int default 19700,
bar198 int default 19800,
bar199 int default 19900,
bar200 int default 20000,
bar201 int default 20100,
bar202 int default 20200,
bar203 int default 20300,
bar204 int default 20400,
bar205 int default 20500,
bar206 int default 20600,
bar207 int default 20700,
bar208 int default 20800,
bar209 int default 20900,
bar210 int default 21000,
bar211 int default 21100,
bar212 int default 21200,
bar213 int default 21300,
bar214 int default 21400,
bar215 int default 21500,
bar216 int default 21600,
bar217 int default 21700,
bar218 int default 21800,
bar219 int default 21900,
bar220 int default 22000,
bar221 int default 22100,
bar222 int default 22200,
bar223 int default 22300,
bar224 int default 22400,
bar225 int default 22500,
bar226 int default 22600,
bar227 int default 22700,
bar228 int default 22800,
bar229 int default 22900,
bar230 int default 23000,
bar231 int default 23100,
bar232 int default 23200,
bar233 int default 23300,
bar234 int default 23400,
bar235 int default 23500,
bar236 int default 23600,
bar237 int default 23700,
bar238 int default 23800,
bar239 int default 23900,
bar240 int default 24000,
bar241 int default 24100,
bar242 int default 24200,
bar243 int default 24300,
bar244 int default 24400,
bar245 int default 24500,
bar246 int default 24600,
bar247 int default 24700,
bar248 int default 24800,
bar249 int default 24900,
bar250 int default 25000,
bar251 int default 25100,
bar252 int default 25200,
bar253 int default 25300,
bar254 int default 25400,
bar255 int default 25500,
bar256 int default 25600,
bar257 int default 25700,
bar258 int default 25800,
bar259 int default 25900,
bar260 int default 26000,
bar261 int default 26100,
bar262 int default 26200,
bar263 int default 26300,
bar264 int default 26400,
bar265 int default 26500,
bar266 int default 26600,
bar267 int default 26700,
bar268 int default 26800,
bar269 int default 26900,
bar270 int default 27000,
bar271 int default 27100,
bar272 int default 27200,
bar273 int default 27300,
bar274 int default 27400,
bar275 int default 27500,
bar276 int default 27600,
bar277 int default 27700,
bar278 int default 27800,
bar279 int default 27900,
bar280 int default 28000,
bar281 int default 28100,
bar282 int default 28200,
bar283 int default 28300,
bar284 int default 28400,
bar285 int default 28500,
bar286 int default 28600,
bar287 int default 28700,
bar288 int default 28800,
bar289 int default 28900,
bar290 int default 29000,
bar291 int default 29100,
bar292 int default 29200,
bar293 int default 29300,
bar294 int default 29400,
bar295 int default 29500,
bar296 int default 29600,
bar297 int default 29700,
bar298 int default 29800,
bar299 int default 29900,
bar300 int default 30000,
bar301 int default 30100,
bar302 int default 30200,
bar303 int default 30300,
bar304 int default 30400,
bar305 int default 30500,
bar306 int default 30600,
bar307 int default 30700,
bar308 int default 30800,
bar309 int default 30900,
bar310 int default 31000,
bar311 int default 31100,
bar312 int default 31200,
bar313 int default 31300,
bar314 int default 31400,
bar315 int default 31500,
bar316 int default 31600,
bar317 int default 31700,
bar318 int default 31800,
bar319 int default 31900,
bar320 int default 32000,
bar321 int default 32100,
bar322 int default 32200,
bar323 int default 32300,
bar324 int default 32400,
bar325 int default 32500,
bar326 int default 32600,
bar327 int default 32700,
bar328 int default 32800,
bar329 int default 32900,
bar330 int default 33000,
bar331 int default 33100,
bar332 int default 33200,
bar333 int default 33300,
bar334 int default 33400,
bar335 int default 33500,
bar336 int default 33600,
bar337 int default 33700,
bar338 int default 33800,
bar339 int default 33900,
bar340 int default 34000,
bar341 int default 34100,
bar342 int default 34200,
bar343 int default 34300,
bar344 int default 34400,
bar345 int default 34500,
bar346 int default 34600,
bar347 int default 34700,
bar348 int default 34800,
bar349 int default 34900,
bar350 int default 35000,
bar351 int default 35100,
bar352 int default 35200,
bar353 int default 35300,
bar354 int default 35400,
bar355 int default 35500,
bar356 int default 35600,
bar357 int default 35700,
bar358 int default 35800,
bar359 int default 35900,
bar360 int default 36000,
bar361 int default 36100,
bar362 int default 36200,
bar363 int default 36300,
bar364 int default 36400,
bar365 int default 36500,
bar366 int default 36600,
bar367 int default 36700,
bar368 int default 36800,
bar369 int default 36900,
bar370 int default 37000,
bar371 int default 37100,
bar372 int default 37200,
bar373 int default 37300,
bar374 int default 37400,
bar375 int default 37500,
bar376 int default 37600,
bar377 int default 37700,
bar378 int default 37800,
bar379 int default 37900,
bar380 int default 38000,
bar381 int default 38100,
bar382 int default 38200,
bar383 int default 38300,
bar384 int default 38400,
bar385 int default 38500,
bar386 int default 38600,
bar387 int default 38700,
bar388 int default 38800,
bar389 int default 38900,
bar390 int default 39000,
bar391 int default 39100,
bar392 int default 39200,
bar393 int default 39300,
bar394 int default 39400,
bar395 int default 39500,
bar396 int default 39600,
bar397 int default 39700,
bar398 int default 39800,
bar399 int default 39900,
bar400 int default 40000,
bar401 int default 40100,
bar402 int default 40200,
bar403 int default 40300,
bar404 int default 40400,
bar405 int default 40500,
bar406 int default 40600,
bar407 int default 40700,
bar408 int default 40800,
bar409 int default 40900,
bar410 int default 41000,
bar411 int default 41100,
bar412 int default 41200,
bar413 int default 41300,
bar414 int default 41400,
bar415 int default 41500,
bar416 int default 41600,
bar417 int default 41700,
bar418 int default 41800,
bar419 int default 41900,
bar420 int default 42000,
bar421 int default 42100,
bar422 int default 42200,
bar423 int default 42300,
bar424 int default 42400,
bar425 int default 42500,
bar426 int default 42600,
bar427 int default 42700,
bar428 int default 42800,
bar429 int default 42900,
bar430 int default 43000,
bar431 int default 43100,
bar432 int default 43200,
bar433 int default 43300,
bar434 int default 43400,
bar435 int default 43500,
bar436 int default 43600,
bar437 int default 43700,
bar438 int default 43800,
bar439 int default 43900,
bar440 int default 44000,
bar441 int default 44100,
bar442 int default 44200,
bar443 int default 44300,
bar444 int default 44400,
bar445 int default 44500,
bar446 int default 44600,
bar447 int default 44700,
bar448 int default 44800,
bar449 int default 44900,
bar450 int default 45000,
bar451 int default 45100,
bar452 int default 45200,
bar453 int default 45300,
bar454 int default 45400,
bar455 int default 45500,
bar456 int default 45600,
bar457 int default 45700,
bar458 int default 45800,
bar459 int default 45900,
bar460 int default 46000,
bar461 int default 46100,
bar462 int default 46200,
bar463 int default 46300,
bar464 int default 46400,
bar465 int default 46500,
bar466 int default 46600,
bar467 int default 46700,
bar468 int default 46800,
bar469 int default 46900,
bar470 int default 47000,
bar471 int default 47100,
bar472 int default 47200,
bar473 int default 47300,
bar474 int default 47400,
bar475 int default 47500,
bar476 int default 47600,
bar477 int default 47700,
bar478 int default 47800,
bar479 int default 47900,
bar480 int default 48000,
bar481 int default 48100,
bar482 int default 48200,
bar483 int default 48300,
bar484 int default 48400,
bar485 int default 48500,
bar486 int default 48600,
bar487 int default 48700,
bar488 int default 48800,
bar489 int default 48900,
bar490 int default 49000,
bar491 int default 49100,
bar492 int default 49200,
bar493 int default 49300,
bar494 int default 49400,
bar495 int default 49500,
bar496 int default 49600,
bar497 int default 49700,
bar498 int default 49800,
bar499 int default 49900,
bar500 int default 50000
);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
insert into big_ass_table2(foo) values (1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment