mysql> select * from poke10; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 10 rows in set (0.01 sec) mysql> select 'My Pokemon', Name from poke10l -> ; ERROR 1146 (42S02): Table 'pokemon.poke10l' doesn't exist mysql> select 'My Pokemon', Name from poke10; +------------+------------+ | My Pokemon | Name | +------------+------------+ | My Pokemon | Caterpie | | My Pokemon | Blastoise | | My Pokemon | Wartortle | | My Pokemon | Squirtle | | My Pokemon | Charizard | | My Pokemon | Charmeleon | | My Pokemon | Charmander | | My Pokemon | Venusaur | | My Pokemon | Ivysaur | | My Pokemon | Bulbasaur | +------------+------------+ 10 rows in set (0.00 sec) mysql> select * from PokeStats; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Genesect | 649 | 15 | 825 | 270 | | Meloetta | 648 | 6 | 65 | 270 | | Keldeo | 647 | 14 | 485 | 261 | | Kyurem | 646 | 30 | 3250 | 297 | | Landorus | 645 | 15 | 680 | 270 | | Zekrom | 644 | 29 | 3450 | 306 | | Reshiram | 643 | 32 | 3300 | 306 | | Thundurus | 642 | 15 | 610 | 261 | | Tornadus | 641 | 15 | 630 | 261 | | Virizion | 640 | 20 | 2000 | 261 | | Terrakion | 639 | 19 | 2600 | 261 | | Cobalion | 638 | 21 | 2500 | 261 | | Volcarona | 637 | 16 | 460 | 248 | | Larvesta | 636 | 11 | 288 | 72 | | Hydreigon | 635 | 18 | 1600 | 270 | | Zweilous | 634 | 14 | 500 | 147 | | Deino | 633 | 8 | 173 | 60 | | Durant | 632 | 3 | 330 | 169 | | Heatmor | 631 | 14 | 580 | 169 | | Mandibuzz | 630 | 12 | 395 | 179 | | Vullaby | 629 | 5 | 90 | 74 | | Braviary | 628 | 15 | 410 | 179 | | Rufflet | 627 | 5 | 105 | 70 | | Bouffalant | 626 | 16 | 946 | 172 | | Bisharp | 625 | 16 | 700 | 172 | | Pawniard | 624 | 5 | 102 | 68 | | Golurk | 623 | 28 | 3300 | 169 | | Golett | 622 | 10 | 920 | 61 | | Druddigon | 621 | 16 | 1390 | 170 | | Mienshao | 620 | 14 | 355 | 179 | | Mienfoo | 619 | 9 | 200 | 70 | | Stunfisk | 618 | 7 | 110 | 165 | | Accelgor | 617 | 8 | 253 | 173 | | Shelmet | 616 | 4 | 77 | 61 | | Cryogonal | 615 | 11 | 1480 | 170 | | Beartic | 614 | 26 | 2600 | 170 | | Cubchoo | 613 | 5 | 85 | 61 | | Haxorus | 612 | 18 | 1055 | 243 | | Fraxure | 611 | 10 | 360 | 144 | | Axew | 610 | 6 | 180 | 64 | | Chandelure | 609 | 10 | 343 | 234 | | Lampent | 608 | 6 | 130 | 130 | | Litwick | 607 | 3 | 31 | 55 | | Beheeyem | 606 | 10 | 345 | 170 | | Elgyem | 605 | 5 | 90 | 67 | | Eelektross | 604 | 21 | 805 | 232 | | Eelektrik | 603 | 12 | 220 | 142 | | Tynamo | 602 | 2 | 3 | 55 | | Klinklang | 601 | 6 | 810 | 234 | | Klang | 600 | 6 | 510 | 154 | | Klink | 599 | 3 | 210 | 60 | | Ferrothorn | 598 | 10 | 1100 | 171 | | Ferroseed | 597 | 6 | 188 | 61 | | Galvantula | 596 | 8 | 143 | 165 | | Joltik | 595 | 1 | 6 | 64 | | Alomomola | 594 | 12 | 316 | 165 | | Jellicent | 593 | 22 | 1350 | 168 | | Frillish | 592 | 12 | 330 | 67 | | Amoonguss | 591 | 6 | 105 | 162 | | Foongus | 590 | 2 | 10 | 59 | | Escavalier | 589 | 10 | 330 | 173 | | Karrablast | 588 | 5 | 59 | 63 | | Emolga | 587 | 4 | 50 | 150 | | Sawsbuck | 586 | 19 | 925 | 166 | | Deerling | 585 | 6 | 195 | 67 | | Vanilluxe | 584 | 13 | 575 | 241 | | Vanillish | 583 | 11 | 410 | 138 | | Vanillite | 582 | 4 | 57 | 61 | | Swanna | 581 | 13 | 242 | 166 | | Ducklett | 580 | 5 | 55 | 61 | | Reuniclus | 579 | 10 | 201 | 221 | | Duosion | 578 | 6 | 80 | 130 | | Solosis | 577 | 3 | 10 | 58 | | Gothitelle | 576 | 15 | 440 | 221 | | Gothorita | 575 | 7 | 180 | 137 | | Gothita | 574 | 4 | 58 | 58 | | Cinccino | 573 | 5 | 75 | 165 | | Minccino | 572 | 4 | 58 | 60 | | Zoroark | 571 | 16 | 811 | 179 | | Zorua | 570 | 7 | 125 | 66 | | Garbodor | 569 | 19 | 1073 | 166 | | Trubbish | 568 | 6 | 310 | 66 | | Archeops | 567 | 14 | 320 | 177 | | Archen | 566 | 5 | 95 | 71 | | Carracosta | 565 | 12 | 810 | 173 | | Tirtouga | 564 | 7 | 165 | 71 | | Cofagrigus | 563 | 17 | 765 | 169 | | Yamask | 562 | 5 | 15 | 61 | | Sigilyph | 561 | 14 | 140 | 172 | | Scrafty | 560 | 11 | 300 | 171 | | Scraggy | 559 | 6 | 118 | 70 | | Crustle | 558 | 14 | 2000 | 166 | | Dwebble | 557 | 3 | 145 | 65 | | Maractus | 556 | 10 | 280 | 161 | | Darmanitan | 555 | 13 | 929 | 168 | | Darumaka | 554 | 6 | 375 | 63 | | Krookodile | 553 | 15 | 963 | 229 | | Krokorok | 552 | 10 | 334 | 123 | | Sandile | 551 | 7 | 152 | 58 | | Basculin | 550 | 10 | 180 | 161 | | Lilligant | 549 | 11 | 163 | 168 | | Petilil | 548 | 5 | 66 | 56 | | Whimsicott | 547 | 7 | 66 | 168 | | Cottonee | 546 | 3 | 6 | 56 | | Scolipede | 545 | 25 | 2005 | 214 | | Whirlipede | 544 | 12 | 585 | 126 | | Venipede | 543 | 4 | 53 | 52 | | Leavanny | 542 | 12 | 205 | 221 | | Swadloon | 541 | 5 | 73 | 133 | | Sewaddle | 540 | 3 | 25 | 62 | | Sawk | 539 | 14 | 510 | 163 | | Throh | 538 | 13 | 555 | 163 | | Seismitoad | 537 | 15 | 620 | 225 | | Palpitoad | 536 | 8 | 170 | 134 | | Tympole | 535 | 5 | 45 | 59 | | Conkeldurr | 534 | 14 | 870 | 227 | | Gurdurr | 533 | 12 | 400 | 142 | | Timburr | 532 | 6 | 125 | 61 | | Audino | 531 | 11 | 310 | 390 | | Excadrill | 530 | 7 | 404 | 178 | | Drilbur | 529 | 3 | 85 | 66 | | Swoobat | 528 | 9 | 105 | 149 | | Woobat | 527 | 4 | 21 | 63 | | Gigalith | 526 | 17 | 2600 | 227 | | Boldore | 525 | 9 | 1020 | 137 | | Roggenrola | 524 | 4 | 180 | 56 | | Zebstrika | 523 | 16 | 795 | 174 | | Blitzle | 522 | 8 | 298 | 59 | | Unfezant | 521 | 12 | 290 | 215 | | Tranquill | 520 | 6 | 150 | 125 | | Pidove | 519 | 3 | 21 | 53 | | Musharna | 518 | 11 | 605 | 170 | | Munna | 517 | 6 | 233 | 58 | | Simipour | 516 | 10 | 290 | 174 | | Panpour | 515 | 6 | 135 | 63 | | Simisear | 514 | 10 | 280 | 174 | | Pansear | 513 | 6 | 110 | 63 | | Simisage | 512 | 11 | 305 | 174 | | Pansage | 511 | 6 | 105 | 63 | | Liepard | 510 | 11 | 375 | 156 | | Purrloin | 509 | 4 | 101 | 56 | | Stoutland | 508 | 12 | 610 | 221 | | Herdier | 507 | 9 | 147 | 130 | | Lillipup | 506 | 4 | 41 | 55 | | Watchog | 505 | 11 | 270 | 147 | | Patrat | 504 | 5 | 116 | 51 | | Samurott | 503 | 15 | 946 | 238 | | Dewott | 502 | 8 | 245 | 145 | | Oshawott | 501 | 5 | 59 | 28 | | Emboar | 500 | 16 | 1500 | 238 | | Pignite | 499 | 10 | 555 | 146 | | Tepig | 498 | 5 | 99 | 28 | | Serperior | 497 | 33 | 630 | 238 | | Servine | 496 | 8 | 160 | 145 | | Snivy | 495 | 6 | 81 | 28 | | Victini | 494 | 4 | 40 | 270 | | Arceus | 493 | 32 | 3200 | 255 | | Shaymin | 492 | 2 | 21 | 64 | | Darkrai | 491 | 15 | 505 | 210 | | Manaphy | 490 | 3 | 14 | 215 | | Phione | 489 | 4 | 31 | 165 | | Cresselia | 488 | 15 | 856 | 210 | | Giratina | 487 | 45 | 7500 | 220 | | Regigigas | 486 | 37 | 4200 | 220 | | Heatran | 485 | 17 | 4300 | 215 | | Palkia | 484 | 42 | 3360 | 220 | | Dialga | 483 | 54 | 6830 | 220 | | Azelf | 482 | 3 | 3 | 210 | | Mesprit | 481 | 3 | 3 | 210 | | Uxie | 480 | 3 | 3 | 210 | | Rotom | 479 | 3 | 3 | 132 | | Froslass | 478 | 13 | 266 | 187 | | Dusknoir | 477 | 22 | 1066 | 210 | | Probopass | 476 | 14 | 3400 | 198 | | Gallade | 475 | 16 | 520 | 208 | | Porygon-Z | 474 | 9 | 340 | 185 | | Mamoswine | 473 | 25 | 2910 | 207 | | Gliscor | 472 | 20 | 425 | 192 | | Glaceon | 471 | 8 | 259 | 196 | | Leafeon | 470 | 10 | 255 | 196 | | Yanmega | 469 | 19 | 515 | 198 | | Togekiss | 468 | 15 | 380 | 220 | | Magmortar | 467 | 16 | 680 | 199 | | Electivire | 466 | 18 | 1386 | 199 | | Tangrowth | 465 | 20 | 1286 | 211 | | Rhyperior | 464 | 24 | 2828 | 217 | | Lickilicky | 463 | 17 | 1400 | 193 | | Magnezone | 462 | 12 | 1800 | 211 | | Weavile | 461 | 11 | 340 | 199 | | Abomasnow | 460 | 22 | 1355 | 214 | | Snover | 459 | 10 | 505 | 131 | | Mantyke | 458 | 10 | 650 | 108 | | Lumineon | 457 | 12 | 240 | 156 | | Finneon | 456 | 4 | 70 | 90 | | Carnivine | 455 | 14 | 270 | 164 | | Toxicroak | 454 | 13 | 444 | 181 | | Croagunk | 453 | 7 | 230 | 83 | | Drapion | 452 | 13 | 615 | 204 | | Skorupi | 451 | 8 | 120 | 114 | | Hippowdon | 450 | 20 | 3000 | 198 | | Hippopotas | 449 | 8 | 495 | 95 | | Lucario | 448 | 12 | 540 | 204 | | Riolu | 447 | 7 | 202 | 72 | | Munchlax | 446 | 6 | 1050 | 94 | | Garchomp | 445 | 19 | 950 | 218 | | Gabite | 444 | 14 | 560 | 144 | | Gible | 443 | 7 | 205 | 67 | | Spiritomb | 442 | 10 | 1080 | 168 | | Chatot | 441 | 5 | 19 | 107 | | Happiny | 440 | 6 | 244 | 255 | | Mime Jr. | 439 | 6 | 130 | 78 | | Bonsly | 438 | 5 | 150 | 68 | | Bronzong | 437 | 13 | 1870 | 188 | | Bronzor | 436 | 5 | 605 | 72 | | Skuntank | 435 | 10 | 380 | 209 | | Stunky | 434 | 4 | 192 | 79 | | Chingling | 433 | 2 | 6 | 74 | | Purugly | 432 | 10 | 438 | 183 | | Glameow | 431 | 5 | 39 | 71 | | Honchkrow | 430 | 9 | 273 | 187 | | Mismagius | 429 | 9 | 44 | 187 | | Lopunny | 428 | 12 | 333 | 178 | | Buneary | 427 | 4 | 55 | 84 | | Drifblim | 426 | 12 | 150 | 204 | | Drifloon | 425 | 4 | 12 | 127 | | Ambipom | 424 | 12 | 203 | 186 | | Gastrodon | 423 | 9 | 299 | 176 | | Shellos | 422 | 3 | 63 | 73 | | Cherrim | 421 | 5 | 93 | 133 | | Cherubi | 420 | 4 | 33 | 68 | | Floatzel | 419 | 11 | 335 | 178 | | Buizel | 418 | 7 | 295 | 75 | | Pachirisu | 417 | 4 | 39 | 120 | | Vespiquen | 416 | 12 | 385 | 188 | | Combee | 415 | 3 | 55 | 63 | | Mothim | 414 | 9 | 233 | 159 | | Wormadam | 413 | 5 | 65 | 159 | | Burmy | 412 | 2 | 34 | 61 | | Bastiodon | 411 | 13 | 1495 | 199 | | Shieldon | 410 | 5 | 570 | 99 | | Rampardos | 409 | 16 | 1025 | 199 | | Cranidos | 408 | 9 | 315 | 99 | | Roserade | 407 | 9 | 145 | 204 | | Budew | 406 | 2 | 12 | 68 | | Luxray | 405 | 14 | 420 | 194 | | Luxio | 404 | 9 | 305 | 117 | | Shinx | 403 | 5 | 95 | 60 | | Kricketune | 402 | 10 | 255 | 159 | | Kricketot | 401 | 3 | 22 | 54 | | Bibarel | 400 | 10 | 315 | 116 | | Bidoof | 399 | 5 | 200 | 58 | | Staraptor | 398 | 12 | 249 | 172 | | Staravia | 397 | 6 | 155 | 113 | | Starly | 396 | 3 | 20 | 56 | | Empoleon | 395 | 17 | 845 | 210 | | Prinplup | 394 | 8 | 230 | 143 | | Piplup | 393 | 4 | 52 | 66 | | Infernape | 392 | 12 | 550 | 209 | | Monferno | 391 | 9 | 220 | 142 | | Chimchar | 390 | 5 | 62 | 65 | | Torterra | 389 | 22 | 3100 | 208 | | Grotle | 388 | 11 | 970 | 141 | | Turtwig | 387 | 4 | 102 | 64 | | Deoxys | 386 | 17 | 608 | 215 | | Jirachi | 385 | 3 | 11 | 215 | | Rayquaza | 384 | 70 | 2065 | 220 | | Groudon | 383 | 35 | 9500 | 218 | | Kyogre | 382 | 45 | 3520 | 218 | | Latios | 381 | 20 | 600 | 211 | | Latias | 380 | 14 | 400 | 211 | | Registeel | 379 | 19 | 2050 | 215 | | Regice | 378 | 18 | 1750 | 216 | | Regirock | 377 | 17 | 2300 | 217 | | Metagross | 376 | 16 | 5500 | 210 | | Metang | 375 | 12 | 2025 | 153 | | Beldum | 374 | 6 | 952 | 103 | | Salamence | 373 | 15 | 1026 | 218 | | Shelgon | 372 | 11 | 1105 | 144 | | Bagon | 371 | 6 | 421 | 89 | | Luvdisc | 370 | 6 | 87 | 110 | | Relicanth | 369 | 10 | 234 | 198 | | Gorebyss | 368 | 18 | 226 | 178 | | Huntail | 367 | 17 | 270 | 178 | | Clamperl | 366 | 4 | 525 | 142 | | Walrein | 365 | 14 | 1506 | 192 | | Sealeo | 364 | 11 | 876 | 128 | | Spheal | 363 | 8 | 395 | 75 | | Glalie | 362 | 15 | 2565 | 187 | | Snorunt | 361 | 7 | 168 | 74 | | Wynaut | 360 | 6 | 140 | 44 | | Absol | 359 | 12 | 470 | 174 | | Chimecho | 358 | 6 | 10 | 147 | | Tropius | 357 | 20 | 1000 | 169 | | Dusclops | 356 | 16 | 306 | 179 | | Duskull | 355 | 8 | 150 | 97 | | Banette | 354 | 11 | 125 | 179 | | Shuppet | 353 | 6 | 23 | 97 | | Kecleon | 352 | 10 | 220 | 132 | | Castform | 351 | 3 | 8 | 145 | | Milotic | 350 | 62 | 1620 | 213 | | Feebas | 349 | 6 | 74 | 61 | | Armaldo | 348 | 15 | 682 | 199 | | Anorith | 347 | 7 | 125 | 99 | | Cradily | 346 | 15 | 604 | 199 | | Lileep | 345 | 10 | 238 | 99 | | Claydol | 344 | 15 | 1080 | 189 | | Baltoy | 343 | 5 | 215 | 58 | | Crawdaunt | 342 | 11 | 328 | 161 | | Corphish | 341 | 6 | 115 | 111 | | Whiscash | 340 | 9 | 236 | 158 | | Barboach | 339 | 4 | 19 | 92 | | Solrock | 338 | 12 | 1540 | 150 | | Lunatone | 337 | 10 | 1680 | 150 | | Seviper | 336 | 27 | 525 | 165 | | Zangoose | 335 | 13 | 403 | 165 | | Altaria | 334 | 11 | 206 | 188 | | Swablu | 333 | 4 | 12 | 74 | | Cacturne | 332 | 13 | 774 | 177 | | Cacnea | 331 | 4 | 513 | 97 | | Flygon | 330 | 20 | 820 | 197 | | Vibrava | 329 | 11 | 153 | 126 | | Trapinch | 328 | 7 | 150 | 73 | | Spinda | 327 | 11 | 50 | 85 | | Grumpig | 326 | 9 | 715 | 164 | | Spoink | 325 | 7 | 306 | 89 | | Torkoal | 324 | 5 | 804 | 161 | | Camerupt | 323 | 19 | 2200 | 175 | | Numel | 322 | 7 | 240 | 88 | | Wailord | 321 | 145 | 3980 | 206 | | Wailmer | 320 | 20 | 1300 | 137 | | Sharpedo | 319 | 18 | 888 | 175 | | Carvanha | 318 | 8 | 208 | 88 | | Swalot | 317 | 17 | 800 | 168 | | Gulpin | 316 | 4 | 103 | 75 | | Roselia | 315 | 3 | 20 | 152 | | Illumise | 314 | 6 | 177 | 146 | | Volbeat | 313 | 7 | 177 | 146 | | Minun | 312 | 4 | 42 | 120 | | Plusle | 311 | 4 | 42 | 120 | | Manectric | 310 | 15 | 402 | 168 | | Electrike | 309 | 6 | 152 | 104 | | Medicham | 308 | 13 | 315 | 153 | | Meditite | 307 | 6 | 112 | 91 | | Aggron | 306 | 21 | 3600 | 205 | | Lairon | 305 | 9 | 1200 | 152 | | Aron | 304 | 4 | 600 | 96 | | Mawile | 303 | 6 | 115 | 98 | | Sableye | 302 | 5 | 110 | 98 | | Delcatty | 301 | 11 | 326 | 138 | | Skitty | 300 | 6 | 110 | 65 | | Nosepass | 299 | 10 | 970 | 108 | | Azurill | 298 | 2 | 20 | 33 | | Hariyama | 297 | 23 | 2538 | 184 | | Makuhita | 296 | 10 | 864 | 87 | | Exploud | 295 | 15 | 840 | 184 | | Loudred | 294 | 10 | 405 | 126 | | Whismur | 293 | 6 | 163 | 68 | | Shedinja | 292 | 8 | 12 | 95 | | Ninjask | 291 | 8 | 120 | 155 | | Nincada | 290 | 5 | 55 | 65 | | Slaking | 289 | 20 | 1305 | 210 | | Vigoroth | 288 | 14 | 465 | 126 | | Slakoth | 287 | 8 | 240 | 83 | | Breloom | 286 | 12 | 392 | 165 | | Shroomish | 285 | 4 | 45 | 65 | | Masquerain | 284 | 8 | 36 | 128 | | Surskit | 283 | 5 | 17 | 63 | | Gardevoir | 282 | 16 | 484 | 208 | | Kirlia | 281 | 8 | 202 | 140 | | Ralts | 280 | 4 | 66 | 70 | | Pelipper | 279 | 12 | 280 | 164 | | Wingull | 278 | 6 | 95 | 64 | | Swellow | 277 | 7 | 198 | 162 | | Taillow | 276 | 3 | 23 | 59 | | Shiftry | 275 | 13 | 596 | 181 | | Nuzleaf | 274 | 10 | 280 | 141 | | Seedot | 273 | 5 | 40 | 74 | | Ludicolo | 272 | 15 | 550 | 181 | | Lombre | 271 | 12 | 325 | 141 | | Lotad | 270 | 5 | 26 | 74 | | Dustox | 269 | 12 | 316 | 161 | | Cascoon | 268 | 7 | 115 | 72 | | Beautifly | 267 | 10 | 284 | 161 | | Silcoon | 266 | 6 | 100 | 72 | | Wurmple | 265 | 3 | 36 | 54 | | Linoone | 264 | 5 | 325 | 128 | | Zigzagoon | 263 | 4 | 175 | 60 | | Mightyena | 262 | 10 | 370 | 128 | | Poochyena | 261 | 5 | 136 | 55 | | Swampert | 260 | 15 | 819 | 210 | | Marshtomp | 259 | 7 | 280 | 143 | | Mudkip | 258 | 4 | 76 | 65 | | Blaziken | 257 | 19 | 520 | 209 | | Combusken | 256 | 9 | 195 | 142 | | Torchic | 255 | 4 | 25 | 65 | | Sceptile | 254 | 17 | 522 | 208 | | Grovyle | 253 | 9 | 216 | 141 | | Treecko | 252 | 5 | 50 | 65 | | Celebi | 251 | 6 | 50 | 64 | | Ho-Oh | 250 | 38 | 1990 | 220 | | Lugia | 249 | 52 | 2160 | 220 | | Tyranitar | 248 | 20 | 2020 | 218 | | Pupitar | 247 | 12 | 1520 | 144 | | Larvitar | 246 | 6 | 720 | 67 | | Suicune | 245 | 20 | 1870 | 215 | | Entei | 244 | 21 | 1980 | 217 | | Raikou | 243 | 19 | 1780 | 216 | | Blissey | 242 | 15 | 468 | 255 | | Miltank | 241 | 12 | 755 | 200 | | Magby | 240 | 7 | 214 | 117 | | Elekid | 239 | 6 | 235 | 106 | | Smoochum | 238 | 4 | 60 | 87 | | Hitmontop | 237 | 14 | 480 | 138 | | Tyrogue | 236 | 7 | 210 | 91 | | Smeargle | 235 | 12 | 580 | 106 | | Stantler | 234 | 14 | 712 | 165 | | Porygon2 | 233 | 6 | 325 | 180 | | Donphan | 232 | 11 | 1200 | 189 | | Phanpy | 231 | 5 | 335 | 124 | | Kingdra | 230 | 18 | 1520 | 207 | | Houndoom | 229 | 14 | 350 | 204 | | Houndour | 228 | 6 | 108 | 114 | | Skarmory | 227 | 17 | 505 | 168 | | Mantine | 226 | 21 | 2200 | 168 | | Delibird | 225 | 9 | 160 | 183 | | Octillery | 224 | 9 | 285 | 164 | | Remoraid | 223 | 6 | 120 | 78 | | Corsola | 222 | 6 | 50 | 113 | | Piloswine | 221 | 11 | 558 | 160 | | Swinub | 220 | 4 | 65 | 78 | | Magcargo | 219 | 8 | 550 | 154 | | Slugma | 218 | 7 | 350 | 78 | | Ursaring | 217 | 18 | 1258 | 189 | | Teddiursa | 216 | 6 | 88 | 124 | | Sneasel | 215 | 9 | 280 | 132 | | Heracross | 214 | 15 | 540 | 200 | | Shuckle | 213 | 6 | 205 | 80 | | Scizor | 212 | 18 | 1180 | 200 | | Qwilfish | 211 | 5 | 39 | 100 | | Granbull | 210 | 14 | 487 | 178 | | Snubbull | 209 | 6 | 78 | 63 | | Steelix | 208 | 92 | 4000 | 196 | | Gligar | 207 | 11 | 648 | 108 | | Dunsparce | 206 | 15 | 140 | 125 | | Forretress | 205 | 12 | 1258 | 118 | | Pineco | 204 | 6 | 72 | 60 | | Girafarig | 203 | 15 | 415 | 149 | | Wobbuffet | 202 | 13 | 285 | 177 | | Unown | 201 | 5 | 50 | 61 | | Misdreavus | 200 | 7 | 10 | 147 | | Slowking | 199 | 20 | 795 | 164 | | Murkrow | 198 | 5 | 21 | 107 | | Umbreon | 197 | 10 | 270 | 197 | | Espeon | 196 | 9 | 265 | 197 | | Quagsire | 195 | 14 | 750 | 137 | | Wooper | 194 | 4 | 85 | 52 | | Yanma | 193 | 12 | 380 | 147 | | Sunflora | 192 | 8 | 85 | 146 | | Sunkern | 191 | 3 | 18 | 52 | | Aipom | 190 | 8 | 115 | 94 | | Jumpluff | 189 | 8 | 30 | 176 | | Skiploom | 188 | 6 | 10 | 136 | | Hoppip | 187 | 4 | 5 | 74 | | Politoed | 186 | 11 | 339 | 185 | | Sudowoodo | 185 | 12 | 380 | 135 | | Azumarill | 184 | 8 | 285 | 153 | | Marill | 183 | 4 | 85 | 58 | | Bellossom | 182 | 4 | 58 | 184 | | Ampharos | 181 | 14 | 615 | 194 | | Flaaffy | 180 | 8 | 133 | 117 | | Mareep | 179 | 6 | 78 | 59 | | Xatu | 178 | 15 | 150 | 171 | | Natu | 177 | 2 | 20 | 73 | | Togetic | 176 | 6 | 32 | 114 | | Togepi | 175 | 3 | 15 | 74 | | Igglybuff | 174 | 3 | 10 | 39 | | Cleffa | 173 | 3 | 30 | 37 | | Pichu | 172 | 3 | 20 | 42 | | Lanturn | 171 | 12 | 225 | 156 | | Chinchou | 170 | 5 | 120 | 90 | | Crobat | 169 | 18 | 750 | 204 | | Ariados | 168 | 11 | 335 | 134 | | Spinarak | 167 | 5 | 85 | 54 | | Ledian | 166 | 14 | 356 | 134 | | Ledyba | 165 | 10 | 108 | 54 | | Noctowl | 164 | 16 | 408 | 162 | | Hoothoot | 163 | 7 | 212 | 58 | | Furret | 162 | 18 | 325 | 116 | | Sentret | 161 | 8 | 60 | 57 | | Feraligatr | 160 | 23 | 888 | 210 | | Croconaw | 159 | 11 | 250 | 143 | | Totodile | 158 | 6 | 95 | 66 | | Typhlosion | 157 | 17 | 795 | 209 | | Quilava | 156 | 9 | 190 | 142 | | Cyndaquil | 155 | 5 | 79 | 65 | | Meganium | 154 | 18 | 1005 | 208 | | Bayleef | 153 | 12 | 158 | 141 | | Chikorita | 152 | 9 | 64 | 64 | | Mew | 151 | 4 | 40 | 64 | | Mewtwo | 150 | 20 | 1220 | 220 | | Dragonite | 149 | 22 | 2100 | 218 | | Dragonair | 148 | 40 | 165 | 144 | | Dratini | 147 | 18 | 33 | 67 | | Moltres | 146 | 20 | 600 | 217 | | Zapdos | 145 | 16 | 526 | 216 | | Articuno | 144 | 17 | 554 | 215 | | Snorlax | 143 | 21 | 4600 | 154 | | Aerodactyl | 142 | 18 | 590 | 202 | | Kabutops | 141 | 13 | 405 | 199 | | Kabuto | 140 | 5 | 115 | 99 | | Omastar | 139 | 10 | 350 | 199 | | Omanyte | 138 | 4 | 75 | 99 | | Porygon | 137 | 8 | 365 | 130 | | Flareon | 136 | 9 | 250 | 198 | | Jolteon | 135 | 8 | 245 | 197 | | Vaporeon | 134 | 10 | 290 | 196 | | Eevee | 133 | 3 | 65 | 92 | | Ditto | 132 | 3 | 40 | 61 | | Lapras | 131 | 25 | 2200 | 219 | | Gyarados | 130 | 65 | 2350 | 214 | | Magikarp | 129 | 9 | 100 | 20 | | Tauros | 128 | 14 | 884 | 211 | | Pinsir | 127 | 15 | 550 | 200 | | Magmar | 126 | 13 | 445 | 167 | | Electabuzz | 125 | 11 | 300 | 156 | | Jynx | 124 | 14 | 406 | 137 | | Scyther | 123 | 15 | 560 | 187 | | Mr. Mime | 122 | 13 | 545 | 136 | | Starmie | 121 | 11 | 800 | 207 | | Staryu | 120 | 8 | 345 | 106 | | Seaking | 119 | 13 | 390 | 170 | | Goldeen | 118 | 6 | 150 | 111 | | Seadra | 117 | 12 | 250 | 155 | | Horsea | 116 | 4 | 80 | 83 | | Kangaskhan | 115 | 22 | 800 | 175 | | Tangela | 114 | 10 | 350 | 166 | | Chansey | 113 | 11 | 346 | 255 | | Rhydon | 112 | 19 | 1200 | 204 | | Rhyhorn | 111 | 10 | 1150 | 135 | | Weezing | 110 | 12 | 95 | 173 | | Koffing | 109 | 6 | 10 | 114 | | Lickitung | 108 | 12 | 655 | 127 | | Hitmonchan | 107 | 14 | 502 | 140 | | Hitmonlee | 106 | 15 | 498 | 139 | | Marowak | 105 | 10 | 450 | 124 | | Cubone | 104 | 4 | 65 | 87 | | Exeggutor | 103 | 20 | 1200 | 212 | | Exeggcute | 102 | 4 | 25 | 98 | | Electrode | 101 | 12 | 666 | 150 | | Voltorb | 100 | 5 | 104 | 103 | | Kingler | 99 | 13 | 600 | 206 | | Krabby | 98 | 4 | 65 | 115 | | Hypno | 97 | 16 | 756 | 165 | | Drowzee | 96 | 10 | 324 | 102 | | Onix | 95 | 88 | 2100 | 108 | | Gengar | 94 | 15 | 405 | 190 | | Haunter | 93 | 16 | 1 | 126 | | Gastly | 92 | 13 | 1 | 95 | | Cloyster | 91 | 15 | 1325 | 203 | | Shellder | 90 | 3 | 40 | 97 | | Muk | 89 | 12 | 300 | 157 | | Grimer | 88 | 9 | 300 | 90 | | Dewgong | 87 | 17 | 1200 | 176 | | Seel | 86 | 11 | 900 | 100 | | Dodrio | 85 | 18 | 852 | 158 | | Doduo | 84 | 14 | 392 | 96 | | Farfetch'd | 83 | 8 | 150 | 94 | | Magneton | 82 | 10 | 600 | 161 | | Magnemite | 81 | 3 | 60 | 89 | | Slowbro | 80 | 16 | 785 | 164 | | Slowpoke | 79 | 12 | 360 | 99 | | Rapidash | 78 | 17 | 950 | 192 | | Ponyta | 77 | 10 | 300 | 152 | | Golem | 76 | 14 | 3000 | 177 | | Graveler | 75 | 10 | 1050 | 134 | | Geodude | 74 | 4 | 200 | 73 | | Tentacruel | 73 | 16 | 550 | 205 | | Tentacool | 72 | 9 | 455 | 105 | | Victreebel | 71 | 17 | 155 | 191 | | Weepinbell | 70 | 10 | 64 | 151 | | Bellsprout | 69 | 7 | 40 | 84 | | Machamp | 68 | 16 | 1300 | 193 | | Machoke | 67 | 15 | 705 | 146 | | Machop | 66 | 8 | 195 | 75 | | Alakazam | 65 | 15 | 480 | 186 | | Kadabra | 64 | 13 | 565 | 145 | | Abra | 63 | 9 | 195 | 75 | | Poliwrath | 62 | 13 | 540 | 185 | | Poliwhirl | 61 | 10 | 200 | 131 | | Poliwag | 60 | 6 | 124 | 77 | | Arcanine | 59 | 19 | 1550 | 213 | | Growlithe | 58 | 7 | 190 | 91 | | Primeape | 57 | 10 | 320 | 149 | | Mankey | 56 | 5 | 280 | 74 | | Golduck | 55 | 17 | 766 | 174 | | Psyduck | 54 | 8 | 196 | 80 | | Persian | 53 | 10 | 320 | 148 | | Meowth | 52 | 4 | 42 | 69 | | Dugtrio | 51 | 7 | 333 | 153 | | Diglett | 50 | 2 | 8 | 81 | | Venomoth | 49 | 15 | 125 | 138 | | Venonat | 48 | 10 | 300 | 75 | | Parasect | 47 | 10 | 295 | 128 | | Paras | 46 | 3 | 54 | 70 | | Vileplume | 45 | 12 | 186 | 184 | | Gloom | 44 | 8 | 86 | 132 | | Oddish | 43 | 5 | 54 | 78 | | Golbat | 42 | 16 | 550 | 171 | | Zubat | 41 | 8 | 75 | 54 | | Wigglytuff | 40 | 10 | 120 | 109 | | Jigglypuff | 39 | 5 | 55 | 76 | | Ninetales | 38 | 11 | 199 | 178 | | Vulpix | 37 | 6 | 99 | 63 | | Clefable | 36 | 13 | 400 | 129 | | Clefairy | 35 | 6 | 75 | 68 | | Nidoking | 34 | 14 | 620 | 195 | | Nidorino | 33 | 9 | 195 | 118 | | Nidoran♂ | 32 | 5 | 90 | 60 | | Nidoqueen | 31 | 13 | 600 | 194 | | Nidorina | 30 | 8 | 200 | 117 | | Nidoran♀ | 29 | 4 | 70 | 59 | | Sandslash | 28 | 10 | 295 | 163 | | Sandshrew | 27 | 6 | 120 | 93 | | Raichu | 26 | 8 | 300 | 122 | | Pikachu | 25 | 4 | 60 | 82 | | Arbok | 24 | 35 | 650 | 147 | | Ekans | 23 | 20 | 69 | 62 | | Fearow | 22 | 12 | 380 | 162 | | Spearow | 21 | 3 | 20 | 58 | | Raticate | 20 | 7 | 185 | 116 | | Rattata | 19 | 3 | 35 | 57 | | Pidgeot | 18 | 15 | 395 | 172 | | Pidgeotto | 17 | 11 | 300 | 113 | | Pidgey | 16 | 3 | 18 | 55 | | Beedrill | 15 | 10 | 295 | 159 | | Kakuna | 14 | 6 | 100 | 71 | | Weedle | 13 | 3 | 32 | 52 | | Butterfree | 12 | 11 | 320 | 160 | | Metapod | 11 | 7 | 99 | 72 | | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 649 rows in set (0.01 sec) mysql> select * from PokeStats where Weight < 20; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Tynamo | 602 | 2 | 3 | 55 | | Joltik | 595 | 1 | 6 | 64 | | Foongus | 590 | 2 | 10 | 59 | | Solosis | 577 | 3 | 10 | 58 | | Yamask | 562 | 5 | 15 | 61 | | Cottonee | 546 | 3 | 6 | 56 | | Manaphy | 490 | 3 | 14 | 215 | | Azelf | 482 | 3 | 3 | 210 | | Mesprit | 481 | 3 | 3 | 210 | | Uxie | 480 | 3 | 3 | 210 | | Rotom | 479 | 3 | 3 | 132 | | Chatot | 441 | 5 | 19 | 107 | | Chingling | 433 | 2 | 6 | 74 | | Drifloon | 425 | 4 | 12 | 127 | | Budew | 406 | 2 | 12 | 68 | | Jirachi | 385 | 3 | 11 | 215 | | Chimecho | 358 | 6 | 10 | 147 | | Castform | 351 | 3 | 8 | 145 | | Barboach | 339 | 4 | 19 | 92 | | Swablu | 333 | 4 | 12 | 74 | | Shedinja | 292 | 8 | 12 | 95 | | Surskit | 283 | 5 | 17 | 63 | | Misdreavus | 200 | 7 | 10 | 147 | | Sunkern | 191 | 3 | 18 | 52 | | Skiploom | 188 | 6 | 10 | 136 | | Hoppip | 187 | 4 | 5 | 74 | | Togepi | 175 | 3 | 15 | 74 | | Igglybuff | 174 | 3 | 10 | 39 | | Koffing | 109 | 6 | 10 | 114 | | Haunter | 93 | 16 | 1 | 126 | | Gastly | 92 | 13 | 1 | 95 | | Diglett | 50 | 2 | 8 | 81 | | Pidgey | 16 | 3 | 18 | 55 | +------------+-----------+--------+--------+----------------+ 33 rows in set (0.00 sec) mysql> select * from PokeStats where Weight < 15; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Tynamo | 602 | 2 | 3 | 55 | | Joltik | 595 | 1 | 6 | 64 | | Foongus | 590 | 2 | 10 | 59 | | Solosis | 577 | 3 | 10 | 58 | | Cottonee | 546 | 3 | 6 | 56 | | Manaphy | 490 | 3 | 14 | 215 | | Azelf | 482 | 3 | 3 | 210 | | Mesprit | 481 | 3 | 3 | 210 | | Uxie | 480 | 3 | 3 | 210 | | Rotom | 479 | 3 | 3 | 132 | | Chingling | 433 | 2 | 6 | 74 | | Drifloon | 425 | 4 | 12 | 127 | | Budew | 406 | 2 | 12 | 68 | | Jirachi | 385 | 3 | 11 | 215 | | Chimecho | 358 | 6 | 10 | 147 | | Castform | 351 | 3 | 8 | 145 | | Swablu | 333 | 4 | 12 | 74 | | Shedinja | 292 | 8 | 12 | 95 | | Misdreavus | 200 | 7 | 10 | 147 | | Skiploom | 188 | 6 | 10 | 136 | | Hoppip | 187 | 4 | 5 | 74 | | Igglybuff | 174 | 3 | 10 | 39 | | Koffing | 109 | 6 | 10 | 114 | | Haunter | 93 | 16 | 1 | 126 | | Gastly | 92 | 13 | 1 | 95 | | Diglett | 50 | 2 | 8 | 81 | +------------+-----------+--------+--------+----------------+ 26 rows in set (0.01 sec) mysql> select * from PokeStats where Weight < 10; +-----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +-----------+-----------+--------+--------+----------------+ | Tynamo | 602 | 2 | 3 | 55 | | Joltik | 595 | 1 | 6 | 64 | | Cottonee | 546 | 3 | 6 | 56 | | Azelf | 482 | 3 | 3 | 210 | | Mesprit | 481 | 3 | 3 | 210 | | Uxie | 480 | 3 | 3 | 210 | | Rotom | 479 | 3 | 3 | 132 | | Chingling | 433 | 2 | 6 | 74 | | Castform | 351 | 3 | 8 | 145 | | Hoppip | 187 | 4 | 5 | 74 | | Haunter | 93 | 16 | 1 | 126 | | Gastly | 92 | 13 | 1 | 95 | | Diglett | 50 | 2 | 8 | 81 | +-----------+-----------+--------+--------+----------------+ 13 rows in set (0.00 sec) mysql> select * from PokeStats where Height < 10; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Meloetta | 648 | 6 | 65 | 270 | | Deino | 633 | 8 | 173 | 60 | | Durant | 632 | 3 | 330 | 169 | | Vullaby | 629 | 5 | 90 | 74 | | Rufflet | 627 | 5 | 105 | 70 | | Pawniard | 624 | 5 | 102 | 68 | | Mienfoo | 619 | 9 | 200 | 70 | | Stunfisk | 618 | 7 | 110 | 165 | | Accelgor | 617 | 8 | 253 | 173 | | Shelmet | 616 | 4 | 77 | 61 | | Cubchoo | 613 | 5 | 85 | 61 | | Axew | 610 | 6 | 180 | 64 | | Lampent | 608 | 6 | 130 | 130 | | Litwick | 607 | 3 | 31 | 55 | | Elgyem | 605 | 5 | 90 | 67 | | Tynamo | 602 | 2 | 3 | 55 | | Klinklang | 601 | 6 | 810 | 234 | | Klang | 600 | 6 | 510 | 154 | | Klink | 599 | 3 | 210 | 60 | | Ferroseed | 597 | 6 | 188 | 61 | | Galvantula | 596 | 8 | 143 | 165 | | Joltik | 595 | 1 | 6 | 64 | | Amoonguss | 591 | 6 | 105 | 162 | | Foongus | 590 | 2 | 10 | 59 | | Karrablast | 588 | 5 | 59 | 63 | | Emolga | 587 | 4 | 50 | 150 | | Deerling | 585 | 6 | 195 | 67 | | Vanillite | 582 | 4 | 57 | 61 | | Ducklett | 580 | 5 | 55 | 61 | | Duosion | 578 | 6 | 80 | 130 | | Solosis | 577 | 3 | 10 | 58 | | Gothorita | 575 | 7 | 180 | 137 | | Gothita | 574 | 4 | 58 | 58 | | Cinccino | 573 | 5 | 75 | 165 | | Minccino | 572 | 4 | 58 | 60 | | Zorua | 570 | 7 | 125 | 66 | | Trubbish | 568 | 6 | 310 | 66 | | Archen | 566 | 5 | 95 | 71 | | Tirtouga | 564 | 7 | 165 | 71 | | Yamask | 562 | 5 | 15 | 61 | | Scraggy | 559 | 6 | 118 | 70 | | Dwebble | 557 | 3 | 145 | 65 | | Darumaka | 554 | 6 | 375 | 63 | | Sandile | 551 | 7 | 152 | 58 | | Petilil | 548 | 5 | 66 | 56 | | Whimsicott | 547 | 7 | 66 | 168 | | Cottonee | 546 | 3 | 6 | 56 | | Venipede | 543 | 4 | 53 | 52 | | Swadloon | 541 | 5 | 73 | 133 | | Sewaddle | 540 | 3 | 25 | 62 | | Palpitoad | 536 | 8 | 170 | 134 | | Tympole | 535 | 5 | 45 | 59 | | Timburr | 532 | 6 | 125 | 61 | | Excadrill | 530 | 7 | 404 | 178 | | Drilbur | 529 | 3 | 85 | 66 | | Swoobat | 528 | 9 | 105 | 149 | | Woobat | 527 | 4 | 21 | 63 | | Boldore | 525 | 9 | 1020 | 137 | | Roggenrola | 524 | 4 | 180 | 56 | | Blitzle | 522 | 8 | 298 | 59 | | Tranquill | 520 | 6 | 150 | 125 | | Pidove | 519 | 3 | 21 | 53 | | Munna | 517 | 6 | 233 | 58 | | Panpour | 515 | 6 | 135 | 63 | | Pansear | 513 | 6 | 110 | 63 | | Pansage | 511 | 6 | 105 | 63 | | Purrloin | 509 | 4 | 101 | 56 | | Herdier | 507 | 9 | 147 | 130 | | Lillipup | 506 | 4 | 41 | 55 | | Patrat | 504 | 5 | 116 | 51 | | Dewott | 502 | 8 | 245 | 145 | | Oshawott | 501 | 5 | 59 | 28 | | Tepig | 498 | 5 | 99 | 28 | | Servine | 496 | 8 | 160 | 145 | | Snivy | 495 | 6 | 81 | 28 | | Victini | 494 | 4 | 40 | 270 | | Shaymin | 492 | 2 | 21 | 64 | | Manaphy | 490 | 3 | 14 | 215 | | Phione | 489 | 4 | 31 | 165 | | Azelf | 482 | 3 | 3 | 210 | | Mesprit | 481 | 3 | 3 | 210 | | Uxie | 480 | 3 | 3 | 210 | | Rotom | 479 | 3 | 3 | 132 | | Porygon-Z | 474 | 9 | 340 | 185 | | Glaceon | 471 | 8 | 259 | 196 | | Finneon | 456 | 4 | 70 | 90 | | Croagunk | 453 | 7 | 230 | 83 | | Skorupi | 451 | 8 | 120 | 114 | | Hippopotas | 449 | 8 | 495 | 95 | | Riolu | 447 | 7 | 202 | 72 | | Munchlax | 446 | 6 | 1050 | 94 | | Gible | 443 | 7 | 205 | 67 | | Chatot | 441 | 5 | 19 | 107 | | Happiny | 440 | 6 | 244 | 255 | | Mime Jr. | 439 | 6 | 130 | 78 | | Bonsly | 438 | 5 | 150 | 68 | | Bronzor | 436 | 5 | 605 | 72 | | Stunky | 434 | 4 | 192 | 79 | | Chingling | 433 | 2 | 6 | 74 | | Glameow | 431 | 5 | 39 | 71 | | Honchkrow | 430 | 9 | 273 | 187 | | Mismagius | 429 | 9 | 44 | 187 | | Buneary | 427 | 4 | 55 | 84 | | Drifloon | 425 | 4 | 12 | 127 | | Gastrodon | 423 | 9 | 299 | 176 | | Shellos | 422 | 3 | 63 | 73 | | Cherrim | 421 | 5 | 93 | 133 | | Cherubi | 420 | 4 | 33 | 68 | | Buizel | 418 | 7 | 295 | 75 | | Pachirisu | 417 | 4 | 39 | 120 | | Combee | 415 | 3 | 55 | 63 | | Mothim | 414 | 9 | 233 | 159 | | Wormadam | 413 | 5 | 65 | 159 | | Burmy | 412 | 2 | 34 | 61 | | Shieldon | 410 | 5 | 570 | 99 | | Cranidos | 408 | 9 | 315 | 99 | | Roserade | 407 | 9 | 145 | 204 | | Budew | 406 | 2 | 12 | 68 | | Luxio | 404 | 9 | 305 | 117 | | Shinx | 403 | 5 | 95 | 60 | | Kricketot | 401 | 3 | 22 | 54 | | Bidoof | 399 | 5 | 200 | 58 | | Staravia | 397 | 6 | 155 | 113 | | Starly | 396 | 3 | 20 | 56 | | Prinplup | 394 | 8 | 230 | 143 | | Piplup | 393 | 4 | 52 | 66 | | Monferno | 391 | 9 | 220 | 142 | | Chimchar | 390 | 5 | 62 | 65 | | Turtwig | 387 | 4 | 102 | 64 | | Jirachi | 385 | 3 | 11 | 215 | | Beldum | 374 | 6 | 952 | 103 | | Bagon | 371 | 6 | 421 | 89 | | Luvdisc | 370 | 6 | 87 | 110 | | Clamperl | 366 | 4 | 525 | 142 | | Spheal | 363 | 8 | 395 | 75 | | Snorunt | 361 | 7 | 168 | 74 | | Wynaut | 360 | 6 | 140 | 44 | | Chimecho | 358 | 6 | 10 | 147 | | Duskull | 355 | 8 | 150 | 97 | | Shuppet | 353 | 6 | 23 | 97 | | Castform | 351 | 3 | 8 | 145 | | Feebas | 349 | 6 | 74 | 61 | | Anorith | 347 | 7 | 125 | 99 | | Baltoy | 343 | 5 | 215 | 58 | | Corphish | 341 | 6 | 115 | 111 | | Whiscash | 340 | 9 | 236 | 158 | | Barboach | 339 | 4 | 19 | 92 | | Swablu | 333 | 4 | 12 | 74 | | Cacnea | 331 | 4 | 513 | 97 | | Trapinch | 328 | 7 | 150 | 73 | | Grumpig | 326 | 9 | 715 | 164 | | Spoink | 325 | 7 | 306 | 89 | | Torkoal | 324 | 5 | 804 | 161 | | Numel | 322 | 7 | 240 | 88 | | Carvanha | 318 | 8 | 208 | 88 | | Gulpin | 316 | 4 | 103 | 75 | | Roselia | 315 | 3 | 20 | 152 | | Illumise | 314 | 6 | 177 | 146 | | Volbeat | 313 | 7 | 177 | 146 | | Minun | 312 | 4 | 42 | 120 | | Plusle | 311 | 4 | 42 | 120 | | Electrike | 309 | 6 | 152 | 104 | | Meditite | 307 | 6 | 112 | 91 | | Lairon | 305 | 9 | 1200 | 152 | | Aron | 304 | 4 | 600 | 96 | | Mawile | 303 | 6 | 115 | 98 | | Sableye | 302 | 5 | 110 | 98 | | Skitty | 300 | 6 | 110 | 65 | | Azurill | 298 | 2 | 20 | 33 | | Whismur | 293 | 6 | 163 | 68 | | Shedinja | 292 | 8 | 12 | 95 | | Ninjask | 291 | 8 | 120 | 155 | | Nincada | 290 | 5 | 55 | 65 | | Slakoth | 287 | 8 | 240 | 83 | | Shroomish | 285 | 4 | 45 | 65 | | Masquerain | 284 | 8 | 36 | 128 | | Surskit | 283 | 5 | 17 | 63 | | Kirlia | 281 | 8 | 202 | 140 | | Ralts | 280 | 4 | 66 | 70 | | Wingull | 278 | 6 | 95 | 64 | | Swellow | 277 | 7 | 198 | 162 | | Taillow | 276 | 3 | 23 | 59 | | Seedot | 273 | 5 | 40 | 74 | | Lotad | 270 | 5 | 26 | 74 | | Cascoon | 268 | 7 | 115 | 72 | | Silcoon | 266 | 6 | 100 | 72 | | Wurmple | 265 | 3 | 36 | 54 | | Linoone | 264 | 5 | 325 | 128 | | Zigzagoon | 263 | 4 | 175 | 60 | | Poochyena | 261 | 5 | 136 | 55 | | Marshtomp | 259 | 7 | 280 | 143 | | Mudkip | 258 | 4 | 76 | 65 | | Combusken | 256 | 9 | 195 | 142 | | Torchic | 255 | 4 | 25 | 65 | | Grovyle | 253 | 9 | 216 | 141 | | Treecko | 252 | 5 | 50 | 65 | | Celebi | 251 | 6 | 50 | 64 | | Larvitar | 246 | 6 | 720 | 67 | | Magby | 240 | 7 | 214 | 117 | | Elekid | 239 | 6 | 235 | 106 | | Smoochum | 238 | 4 | 60 | 87 | | Tyrogue | 236 | 7 | 210 | 91 | | Porygon2 | 233 | 6 | 325 | 180 | | Phanpy | 231 | 5 | 335 | 124 | | Houndour | 228 | 6 | 108 | 114 | | Delibird | 225 | 9 | 160 | 183 | | Octillery | 224 | 9 | 285 | 164 | | Remoraid | 223 | 6 | 120 | 78 | | Corsola | 222 | 6 | 50 | 113 | | Swinub | 220 | 4 | 65 | 78 | | Magcargo | 219 | 8 | 550 | 154 | | Slugma | 218 | 7 | 350 | 78 | | Teddiursa | 216 | 6 | 88 | 124 | | Sneasel | 215 | 9 | 280 | 132 | | Shuckle | 213 | 6 | 205 | 80 | | Qwilfish | 211 | 5 | 39 | 100 | | Snubbull | 209 | 6 | 78 | 63 | | Pineco | 204 | 6 | 72 | 60 | | Unown | 201 | 5 | 50 | 61 | | Misdreavus | 200 | 7 | 10 | 147 | | Murkrow | 198 | 5 | 21 | 107 | | Espeon | 196 | 9 | 265 | 197 | | Wooper | 194 | 4 | 85 | 52 | | Sunflora | 192 | 8 | 85 | 146 | | Sunkern | 191 | 3 | 18 | 52 | | Aipom | 190 | 8 | 115 | 94 | | Jumpluff | 189 | 8 | 30 | 176 | | Skiploom | 188 | 6 | 10 | 136 | | Hoppip | 187 | 4 | 5 | 74 | | Azumarill | 184 | 8 | 285 | 153 | | Marill | 183 | 4 | 85 | 58 | | Bellossom | 182 | 4 | 58 | 184 | | Flaaffy | 180 | 8 | 133 | 117 | | Mareep | 179 | 6 | 78 | 59 | | Natu | 177 | 2 | 20 | 73 | | Togetic | 176 | 6 | 32 | 114 | | Togepi | 175 | 3 | 15 | 74 | | Igglybuff | 174 | 3 | 10 | 39 | | Cleffa | 173 | 3 | 30 | 37 | | Pichu | 172 | 3 | 20 | 42 | | Chinchou | 170 | 5 | 120 | 90 | | Spinarak | 167 | 5 | 85 | 54 | | Hoothoot | 163 | 7 | 212 | 58 | | Sentret | 161 | 8 | 60 | 57 | | Totodile | 158 | 6 | 95 | 66 | | Quilava | 156 | 9 | 190 | 142 | | Cyndaquil | 155 | 5 | 79 | 65 | | Chikorita | 152 | 9 | 64 | 64 | | Mew | 151 | 4 | 40 | 64 | | Kabuto | 140 | 5 | 115 | 99 | | Omanyte | 138 | 4 | 75 | 99 | | Porygon | 137 | 8 | 365 | 130 | | Flareon | 136 | 9 | 250 | 198 | | Jolteon | 135 | 8 | 245 | 197 | | Eevee | 133 | 3 | 65 | 92 | | Ditto | 132 | 3 | 40 | 61 | | Magikarp | 129 | 9 | 100 | 20 | | Staryu | 120 | 8 | 345 | 106 | | Goldeen | 118 | 6 | 150 | 111 | | Horsea | 116 | 4 | 80 | 83 | | Koffing | 109 | 6 | 10 | 114 | | Cubone | 104 | 4 | 65 | 87 | | Exeggcute | 102 | 4 | 25 | 98 | | Voltorb | 100 | 5 | 104 | 103 | | Krabby | 98 | 4 | 65 | 115 | | Shellder | 90 | 3 | 40 | 97 | | Grimer | 88 | 9 | 300 | 90 | | Farfetch'd | 83 | 8 | 150 | 94 | | Magnemite | 81 | 3 | 60 | 89 | | Geodude | 74 | 4 | 200 | 73 | | Tentacool | 72 | 9 | 455 | 105 | | Bellsprout | 69 | 7 | 40 | 84 | | Machop | 66 | 8 | 195 | 75 | | Abra | 63 | 9 | 195 | 75 | | Poliwag | 60 | 6 | 124 | 77 | | Growlithe | 58 | 7 | 190 | 91 | | Mankey | 56 | 5 | 280 | 74 | | Psyduck | 54 | 8 | 196 | 80 | | Meowth | 52 | 4 | 42 | 69 | | Dugtrio | 51 | 7 | 333 | 153 | | Diglett | 50 | 2 | 8 | 81 | | Paras | 46 | 3 | 54 | 70 | | Gloom | 44 | 8 | 86 | 132 | | Oddish | 43 | 5 | 54 | 78 | | Zubat | 41 | 8 | 75 | 54 | | Jigglypuff | 39 | 5 | 55 | 76 | | Vulpix | 37 | 6 | 99 | 63 | | Clefairy | 35 | 6 | 75 | 68 | | Nidorino | 33 | 9 | 195 | 118 | | Nidoran♂ | 32 | 5 | 90 | 60 | | Nidorina | 30 | 8 | 200 | 117 | | Nidoran♀ | 29 | 4 | 70 | 59 | | Sandshrew | 27 | 6 | 120 | 93 | | Raichu | 26 | 8 | 300 | 122 | | Pikachu | 25 | 4 | 60 | 82 | | Spearow | 21 | 3 | 20 | 58 | | Raticate | 20 | 7 | 185 | 116 | | Rattata | 19 | 3 | 35 | 57 | | Pidgey | 16 | 3 | 18 | 55 | | Kakuna | 14 | 6 | 100 | 71 | | Weedle | 13 | 3 | 32 | 52 | | Metapod | 11 | 7 | 99 | 72 | | Caterpie | 10 | 3 | 29 | 53 | | Squirtle | 7 | 5 | 90 | 66 | | Charmander | 4 | 6 | 85 | 65 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 306 rows in set (0.00 sec) mysql> select * from PokeStats where Height < 5; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Durant | 632 | 3 | 330 | 169 | | Shelmet | 616 | 4 | 77 | 61 | | Litwick | 607 | 3 | 31 | 55 | | Tynamo | 602 | 2 | 3 | 55 | | Klink | 599 | 3 | 210 | 60 | | Joltik | 595 | 1 | 6 | 64 | | Foongus | 590 | 2 | 10 | 59 | | Emolga | 587 | 4 | 50 | 150 | | Vanillite | 582 | 4 | 57 | 61 | | Solosis | 577 | 3 | 10 | 58 | | Gothita | 574 | 4 | 58 | 58 | | Minccino | 572 | 4 | 58 | 60 | | Dwebble | 557 | 3 | 145 | 65 | | Cottonee | 546 | 3 | 6 | 56 | | Venipede | 543 | 4 | 53 | 52 | | Sewaddle | 540 | 3 | 25 | 62 | | Drilbur | 529 | 3 | 85 | 66 | | Woobat | 527 | 4 | 21 | 63 | | Roggenrola | 524 | 4 | 180 | 56 | | Pidove | 519 | 3 | 21 | 53 | | Purrloin | 509 | 4 | 101 | 56 | | Lillipup | 506 | 4 | 41 | 55 | | Victini | 494 | 4 | 40 | 270 | | Shaymin | 492 | 2 | 21 | 64 | | Manaphy | 490 | 3 | 14 | 215 | | Phione | 489 | 4 | 31 | 165 | | Azelf | 482 | 3 | 3 | 210 | | Mesprit | 481 | 3 | 3 | 210 | | Uxie | 480 | 3 | 3 | 210 | | Rotom | 479 | 3 | 3 | 132 | | Finneon | 456 | 4 | 70 | 90 | | Stunky | 434 | 4 | 192 | 79 | | Chingling | 433 | 2 | 6 | 74 | | Buneary | 427 | 4 | 55 | 84 | | Drifloon | 425 | 4 | 12 | 127 | | Shellos | 422 | 3 | 63 | 73 | | Cherubi | 420 | 4 | 33 | 68 | | Pachirisu | 417 | 4 | 39 | 120 | | Combee | 415 | 3 | 55 | 63 | | Burmy | 412 | 2 | 34 | 61 | | Budew | 406 | 2 | 12 | 68 | | Kricketot | 401 | 3 | 22 | 54 | | Starly | 396 | 3 | 20 | 56 | | Piplup | 393 | 4 | 52 | 66 | | Turtwig | 387 | 4 | 102 | 64 | | Jirachi | 385 | 3 | 11 | 215 | | Clamperl | 366 | 4 | 525 | 142 | | Castform | 351 | 3 | 8 | 145 | | Barboach | 339 | 4 | 19 | 92 | | Swablu | 333 | 4 | 12 | 74 | | Cacnea | 331 | 4 | 513 | 97 | | Gulpin | 316 | 4 | 103 | 75 | | Roselia | 315 | 3 | 20 | 152 | | Minun | 312 | 4 | 42 | 120 | | Plusle | 311 | 4 | 42 | 120 | | Aron | 304 | 4 | 600 | 96 | | Azurill | 298 | 2 | 20 | 33 | | Shroomish | 285 | 4 | 45 | 65 | | Ralts | 280 | 4 | 66 | 70 | | Taillow | 276 | 3 | 23 | 59 | | Wurmple | 265 | 3 | 36 | 54 | | Zigzagoon | 263 | 4 | 175 | 60 | | Mudkip | 258 | 4 | 76 | 65 | | Torchic | 255 | 4 | 25 | 65 | | Smoochum | 238 | 4 | 60 | 87 | | Swinub | 220 | 4 | 65 | 78 | | Wooper | 194 | 4 | 85 | 52 | | Sunkern | 191 | 3 | 18 | 52 | | Hoppip | 187 | 4 | 5 | 74 | | Marill | 183 | 4 | 85 | 58 | | Bellossom | 182 | 4 | 58 | 184 | | Natu | 177 | 2 | 20 | 73 | | Togepi | 175 | 3 | 15 | 74 | | Igglybuff | 174 | 3 | 10 | 39 | | Cleffa | 173 | 3 | 30 | 37 | | Pichu | 172 | 3 | 20 | 42 | | Mew | 151 | 4 | 40 | 64 | | Omanyte | 138 | 4 | 75 | 99 | | Eevee | 133 | 3 | 65 | 92 | | Ditto | 132 | 3 | 40 | 61 | | Horsea | 116 | 4 | 80 | 83 | | Cubone | 104 | 4 | 65 | 87 | | Exeggcute | 102 | 4 | 25 | 98 | | Krabby | 98 | 4 | 65 | 115 | | Shellder | 90 | 3 | 40 | 97 | | Magnemite | 81 | 3 | 60 | 89 | | Geodude | 74 | 4 | 200 | 73 | | Meowth | 52 | 4 | 42 | 69 | | Diglett | 50 | 2 | 8 | 81 | | Paras | 46 | 3 | 54 | 70 | | Nidoran♀ | 29 | 4 | 70 | 59 | | Pikachu | 25 | 4 | 60 | 82 | | Spearow | 21 | 3 | 20 | 58 | | Rattata | 19 | 3 | 35 | 57 | | Pidgey | 16 | 3 | 18 | 55 | | Weedle | 13 | 3 | 32 | 52 | | Caterpie | 10 | 3 | 29 | 53 | +------------+-----------+--------+--------+----------------+ 97 rows in set (0.00 sec) mysql> select * from PokeStats where Height =4; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Shelmet | 616 | 4 | 77 | 61 | | Emolga | 587 | 4 | 50 | 150 | | Vanillite | 582 | 4 | 57 | 61 | | Gothita | 574 | 4 | 58 | 58 | | Minccino | 572 | 4 | 58 | 60 | | Venipede | 543 | 4 | 53 | 52 | | Woobat | 527 | 4 | 21 | 63 | | Roggenrola | 524 | 4 | 180 | 56 | | Purrloin | 509 | 4 | 101 | 56 | | Lillipup | 506 | 4 | 41 | 55 | | Victini | 494 | 4 | 40 | 270 | | Phione | 489 | 4 | 31 | 165 | | Finneon | 456 | 4 | 70 | 90 | | Stunky | 434 | 4 | 192 | 79 | | Buneary | 427 | 4 | 55 | 84 | | Drifloon | 425 | 4 | 12 | 127 | | Cherubi | 420 | 4 | 33 | 68 | | Pachirisu | 417 | 4 | 39 | 120 | | Piplup | 393 | 4 | 52 | 66 | | Turtwig | 387 | 4 | 102 | 64 | | Clamperl | 366 | 4 | 525 | 142 | | Barboach | 339 | 4 | 19 | 92 | | Swablu | 333 | 4 | 12 | 74 | | Cacnea | 331 | 4 | 513 | 97 | | Gulpin | 316 | 4 | 103 | 75 | | Minun | 312 | 4 | 42 | 120 | | Plusle | 311 | 4 | 42 | 120 | | Aron | 304 | 4 | 600 | 96 | | Shroomish | 285 | 4 | 45 | 65 | | Ralts | 280 | 4 | 66 | 70 | | Zigzagoon | 263 | 4 | 175 | 60 | | Mudkip | 258 | 4 | 76 | 65 | | Torchic | 255 | 4 | 25 | 65 | | Smoochum | 238 | 4 | 60 | 87 | | Swinub | 220 | 4 | 65 | 78 | | Wooper | 194 | 4 | 85 | 52 | | Hoppip | 187 | 4 | 5 | 74 | | Marill | 183 | 4 | 85 | 58 | | Bellossom | 182 | 4 | 58 | 184 | | Mew | 151 | 4 | 40 | 64 | | Omanyte | 138 | 4 | 75 | 99 | | Horsea | 116 | 4 | 80 | 83 | | Cubone | 104 | 4 | 65 | 87 | | Exeggcute | 102 | 4 | 25 | 98 | | Krabby | 98 | 4 | 65 | 115 | | Geodude | 74 | 4 | 200 | 73 | | Meowth | 52 | 4 | 42 | 69 | | Nidoran♀ | 29 | 4 | 70 | 59 | | Pikachu | 25 | 4 | 60 | 82 | +------------+-----------+--------+--------+----------------+ 49 rows in set (0.01 sec) mysql> select * from PokeStats where Height =4 and weight < 20; +----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +----------+-----------+--------+--------+----------------+ | Drifloon | 425 | 4 | 12 | 127 | | Barboach | 339 | 4 | 19 | 92 | | Swablu | 333 | 4 | 12 | 74 | | Hoppip | 187 | 4 | 5 | 74 | +----------+-----------+--------+--------+----------------+ 4 rows in set (0.00 sec) mysql> select * from poke10; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 10 rows in set (0.00 sec) mysql> select * from PokeState where height = 3 and Weight > 20 and Weight < 30; ERROR 1146 (42S02): Table 'pokemon.PokeState' doesn't exist mysql> select * from PokeStats where height = 3 and Weight > 20 and Weight < 30; +-----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +-----------+-----------+--------+--------+----------------+ | Sewaddle | 540 | 3 | 25 | 62 | | Pidove | 519 | 3 | 21 | 53 | | Kricketot | 401 | 3 | 22 | 54 | | Taillow | 276 | 3 | 23 | 59 | | Caterpie | 10 | 3 | 29 | 53 | +-----------+-----------+--------+--------+----------------+ 5 rows in set (0.00 sec) mysql> create table poke5 as (select * from PokeStats where height = 3 and Weight > 20 and Weight < 30); Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> select * from poke5; +-----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +-----------+-----------+--------+--------+----------------+ | Sewaddle | 540 | 3 | 25 | 62 | | Pidove | 519 | 3 | 21 | 53 | | Kricketot | 401 | 3 | 22 | 54 | | Taillow | 276 | 3 | 23 | 59 | | Caterpie | 10 | 3 | 29 | 53 | +-----------+-----------+--------+--------+----------------+ 5 rows in set (0.00 sec) mysql> select * from poke10; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 10 rows in set (0.00 sec) mysql> poke10 UNION poke5; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'poke10 UNION poke5' at line 1 mysql> (SELECT * from poke10) -> UNION -> (SELECT * from poke5); +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | | Sewaddle | 540 | 3 | 25 | 62 | | Pidove | 519 | 3 | 21 | 53 | | Kricketot | 401 | 3 | 22 | 54 | | Taillow | 276 | 3 | 23 | 59 | +------------+-----------+--------+--------+----------------+ 14 rows in set (0.01 sec) mysql> (SELECT 'first', poke10.* from poke10) UNION (SELECT 'second', poke5.* from poke5); +--------+------------+-----------+--------+--------+----------------+ | first | Name | PokedexID | Height | Weight | BaseExperience | +--------+------------+-----------+--------+--------+----------------+ | first | Caterpie | 10 | 3 | 29 | 53 | | first | Blastoise | 9 | 16 | 855 | 210 | | first | Wartortle | 8 | 10 | 225 | 143 | | first | Squirtle | 7 | 5 | 90 | 66 | | first | Charizard | 6 | 17 | 905 | 209 | | first | Charmeleon | 5 | 11 | 190 | 142 | | first | Charmander | 4 | 6 | 85 | 65 | | first | Venusaur | 3 | 20 | 1000 | 208 | | first | Ivysaur | 2 | 10 | 130 | 141 | | first | Bulbasaur | 1 | 7 | 69 | 64 | | second | Sewaddle | 540 | 3 | 25 | 62 | | second | Pidove | 519 | 3 | 21 | 53 | | second | Kricketot | 401 | 3 | 22 | 54 | | second | Taillow | 276 | 3 | 23 | 59 | | second | Caterpie | 10 | 3 | 29 | 53 | +--------+------------+-----------+--------+--------+----------------+ 15 rows in set (0.00 sec) mysql> (SELECT 'first', poke10.* from poke10 where height < 5) UNION (SELECT 'second', poke5.* from poke5); +--------+-----------+-----------+--------+--------+----------------+ | first | Name | PokedexID | Height | Weight | BaseExperience | +--------+-----------+-----------+--------+--------+----------------+ | first | Caterpie | 10 | 3 | 29 | 53 | | second | Sewaddle | 540 | 3 | 25 | 62 | | second | Pidove | 519 | 3 | 21 | 53 | | second | Kricketot | 401 | 3 | 22 | 54 | | second | Taillow | 276 | 3 | 23 | 59 | | second | Caterpie | 10 | 3 | 29 | 53 | +--------+-----------+-----------+--------+--------+----------------+ 6 rows in set (0.00 sec) mysql> (SELECT 'first', poke10.* from poke10 where weight > 26) UNION (SELECT 'second', poke5.* from poke5); +--------+------------+-----------+--------+--------+----------------+ | first | Name | PokedexID | Height | Weight | BaseExperience | +--------+------------+-----------+--------+--------+----------------+ | first | Caterpie | 10 | 3 | 29 | 53 | | first | Blastoise | 9 | 16 | 855 | 210 | | first | Wartortle | 8 | 10 | 225 | 143 | | first | Squirtle | 7 | 5 | 90 | 66 | | first | Charizard | 6 | 17 | 905 | 209 | | first | Charmeleon | 5 | 11 | 190 | 142 | | first | Charmander | 4 | 6 | 85 | 65 | | first | Venusaur | 3 | 20 | 1000 | 208 | | first | Ivysaur | 2 | 10 | 130 | 141 | | first | Bulbasaur | 1 | 7 | 69 | 64 | | second | Sewaddle | 540 | 3 | 25 | 62 | | second | Pidove | 519 | 3 | 21 | 53 | | second | Kricketot | 401 | 3 | 22 | 54 | | second | Taillow | 276 | 3 | 23 | 59 | | second | Caterpie | 10 | 3 | 29 | 53 | +--------+------------+-----------+--------+--------+----------------+ 15 rows in set (0.01 sec) mysql> (SELECT 'first', poke10.* from poke10 where weight < 260) UNION (SELECT 'second', poke5.* from poke5); +--------+------------+-----------+--------+--------+----------------+ | first | Name | PokedexID | Height | Weight | BaseExperience | +--------+------------+-----------+--------+--------+----------------+ | first | Caterpie | 10 | 3 | 29 | 53 | | first | Wartortle | 8 | 10 | 225 | 143 | | first | Squirtle | 7 | 5 | 90 | 66 | | first | Charmeleon | 5 | 11 | 190 | 142 | | first | Charmander | 4 | 6 | 85 | 65 | | first | Ivysaur | 2 | 10 | 130 | 141 | | first | Bulbasaur | 1 | 7 | 69 | 64 | | second | Sewaddle | 540 | 3 | 25 | 62 | | second | Pidove | 519 | 3 | 21 | 53 | | second | Kricketot | 401 | 3 | 22 | 54 | | second | Taillow | 276 | 3 | 23 | 59 | | second | Caterpie | 10 | 3 | 29 | 53 | +--------+------------+-----------+--------+--------+----------------+ 12 rows in set (0.01 sec) mysql> (SELECT 'first', poke10.* from poke10 where weight < 260) UNION (SELECT 23, poke5.* from poke5); +-------+------------+-----------+--------+--------+----------------+ | first | Name | PokedexID | Height | Weight | BaseExperience | +-------+------------+-----------+--------+--------+----------------+ | first | Caterpie | 10 | 3 | 29 | 53 | | first | Wartortle | 8 | 10 | 225 | 143 | | first | Squirtle | 7 | 5 | 90 | 66 | | first | Charmeleon | 5 | 11 | 190 | 142 | | first | Charmander | 4 | 6 | 85 | 65 | | first | Ivysaur | 2 | 10 | 130 | 141 | | first | Bulbasaur | 1 | 7 | 69 | 64 | | 23 | Sewaddle | 540 | 3 | 25 | 62 | | 23 | Pidove | 519 | 3 | 21 | 53 | | 23 | Kricketot | 401 | 3 | 22 | 54 | | 23 | Taillow | 276 | 3 | 23 | 59 | | 23 | Caterpie | 10 | 3 | 29 | 53 | +-------+------------+-----------+--------+--------+----------------+ 12 rows in set (0.00 sec) mysql> (SELECT TRUE, poke10.* from poke10 where weight < 260) UNION (SELECT 23, poke5.* from poke5); +------+------------+-----------+--------+--------+----------------+ | TRUE | Name | PokedexID | Height | Weight | BaseExperience | +------+------------+-----------+--------+--------+----------------+ | 1 | Caterpie | 10 | 3 | 29 | 53 | | 1 | Wartortle | 8 | 10 | 225 | 143 | | 1 | Squirtle | 7 | 5 | 90 | 66 | | 1 | Charmeleon | 5 | 11 | 190 | 142 | | 1 | Charmander | 4 | 6 | 85 | 65 | | 1 | Ivysaur | 2 | 10 | 130 | 141 | | 1 | Bulbasaur | 1 | 7 | 69 | 64 | | 23 | Sewaddle | 540 | 3 | 25 | 62 | | 23 | Pidove | 519 | 3 | 21 | 53 | | 23 | Kricketot | 401 | 3 | 22 | 54 | | 23 | Taillow | 276 | 3 | 23 | 59 | | 23 | Caterpie | 10 | 3 | 29 | 53 | +------+------------+-----------+--------+--------+----------------+ 12 rows in set (0.00 sec) mysql> (select name, height from poke10) union (select weight, Name from poke5); +------------+-----------+ | name | height | +------------+-----------+ | Caterpie | 3 | | Blastoise | 16 | | Wartortle | 10 | | Squirtle | 5 | | Charizard | 17 | | Charmeleon | 11 | | Charmander | 6 | | Venusaur | 20 | | Ivysaur | 10 | | Bulbasaur | 7 | | 25 | Sewaddle | | 21 | Pidove | | 22 | Kricketot | | 23 | Taillow | | 29 | Caterpie | +------------+-----------+ 15 rows in set (0.00 sec) mysql> (SELECT 'first', poke10.* from poke10 where weight < 260) UNION (SELECT 'second', poke5.* from poke5); +--------+------------+-----------+--------+--------+----------------+ | first | Name | PokedexID | Height | Weight | BaseExperience | +--------+------------+-----------+--------+--------+----------------+ | first | Caterpie | 10 | 3 | 29 | 53 | | first | Wartortle | 8 | 10 | 225 | 143 | | first | Squirtle | 7 | 5 | 90 | 66 | | first | Charmeleon | 5 | 11 | 190 | 142 | | first | Charmander | 4 | 6 | 85 | 65 | | first | Ivysaur | 2 | 10 | 130 | 141 | | first | Bulbasaur | 1 | 7 | 69 | 64 | | second | Sewaddle | 540 | 3 | 25 | 62 | | second | Pidove | 519 | 3 | 21 | 53 | | second | Kricketot | 401 | 3 | 22 | 54 | | second | Taillow | 276 | 3 | 23 | 59 | | second | Caterpie | 10 | 3 | 29 | 53 | +--------+------------+-----------+--------+--------+----------------+ 12 rows in set (0.00 sec) mysql> select * from poke10s; +------------+-----------+--------+--------+----------------+-------------+ | Name | PokedexID | Height | Weight | BaseExperience | Genus | +------------+-----------+--------+--------+----------------+-------------+ | Caterpie | 10 | 3 | 29 | 53 | Worm | | Blastoise | 9 | 16 | 855 | 210 | Shellfish | | Wartortle | 8 | 10 | 225 | 143 | Turtle | | Squirtle | 7 | 5 | 90 | 66 | Tiny Turtle | | Charizard | 6 | 17 | 905 | 209 | Flame | | Charmeleon | 5 | 11 | 190 | 142 | Flame | | Charmander | 4 | 6 | 85 | 65 | Lizard | | Venusaur | 3 | 20 | 1000 | 208 | Seed | | Ivysaur | 2 | 10 | 130 | 141 | Seed | | Bulbasaur | 1 | 7 | 69 | 64 | Seed | +------------+-----------+--------+--------+----------------+-------------+ 10 rows in set (0.01 sec) mysql> create table pokefoo as (select PokedexId, Name, Genus from poke10s); Query OK, 10 rows affected (0.02 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from pokefoo; +-----------+------------+-------------+ | PokedexId | Name | Genus | +-----------+------------+-------------+ | 10 | Caterpie | Worm | | 9 | Blastoise | Shellfish | | 8 | Wartortle | Turtle | | 7 | Squirtle | Tiny Turtle | | 6 | Charizard | Flame | | 5 | Charmeleon | Flame | | 4 | Charmander | Lizard | | 3 | Venusaur | Seed | | 2 | Ivysaur | Seed | | 1 | Bulbasaur | Seed | +-----------+------------+-------------+ 10 rows in set (0.01 sec) mysql> select * -> from poke10 p, pokefoo s -> where p.Pokedexid = s.pokedexid and p.name = s.name; +------------+-----------+--------+--------+----------------+-----------+------------+-------------+ | Name | PokedexID | Height | Weight | BaseExperience | PokedexId | Name | Genus | +------------+-----------+--------+--------+----------------+-----------+------------+-------------+ | Caterpie | 10 | 3 | 29 | 53 | 10 | Caterpie | Worm | | Blastoise | 9 | 16 | 855 | 210 | 9 | Blastoise | Shellfish | | Wartortle | 8 | 10 | 225 | 143 | 8 | Wartortle | Turtle | | Squirtle | 7 | 5 | 90 | 66 | 7 | Squirtle | Tiny Turtle | | Charizard | 6 | 17 | 905 | 209 | 6 | Charizard | Flame | | Charmeleon | 5 | 11 | 190 | 142 | 5 | Charmeleon | Flame | | Charmander | 4 | 6 | 85 | 65 | 4 | Charmander | Lizard | | Venusaur | 3 | 20 | 1000 | 208 | 3 | Venusaur | Seed | | Ivysaur | 2 | 10 | 130 | 141 | 2 | Ivysaur | Seed | | Bulbasaur | 1 | 7 | 69 | 64 | 1 | Bulbasaur | Seed | +------------+-----------+--------+--------+----------------+-----------+------------+-------------+ 10 rows in set (0.01 sec) mysql> select p.*, s.genus from poke10 p, pokefoo s where p.Pokedexid = s.pokedexid and p.name = s.name; +------------+-----------+--------+--------+----------------+-------------+ | Name | PokedexID | Height | Weight | BaseExperience | genus | +------------+-----------+--------+--------+----------------+-------------+ | Caterpie | 10 | 3 | 29 | 53 | Worm | | Blastoise | 9 | 16 | 855 | 210 | Shellfish | | Wartortle | 8 | 10 | 225 | 143 | Turtle | | Squirtle | 7 | 5 | 90 | 66 | Tiny Turtle | | Charizard | 6 | 17 | 905 | 209 | Flame | | Charmeleon | 5 | 11 | 190 | 142 | Flame | | Charmander | 4 | 6 | 85 | 65 | Lizard | | Venusaur | 3 | 20 | 1000 | 208 | Seed | | Ivysaur | 2 | 10 | 130 | 141 | Seed | | Bulbasaur | 1 | 7 | 69 | 64 | Seed | +------------+-----------+--------+--------+----------------+-------------+ 10 rows in set (0.00 sec) mysql> select * -> FROM poke10 NATURAL JOIN pokefoo; +------------+-----------+--------+--------+----------------+-------------+ | Name | PokedexID | Height | Weight | BaseExperience | Genus | +------------+-----------+--------+--------+----------------+-------------+ | Caterpie | 10 | 3 | 29 | 53 | Worm | | Blastoise | 9 | 16 | 855 | 210 | Shellfish | | Wartortle | 8 | 10 | 225 | 143 | Turtle | | Squirtle | 7 | 5 | 90 | 66 | Tiny Turtle | | Charizard | 6 | 17 | 905 | 209 | Flame | | Charmeleon | 5 | 11 | 190 | 142 | Flame | | Charmander | 4 | 6 | 85 | 65 | Lizard | | Venusaur | 3 | 20 | 1000 | 208 | Seed | | Ivysaur | 2 | 10 | 130 | 141 | Seed | | Bulbasaur | 1 | 7 | 69 | 64 | Seed | +------------+-----------+--------+--------+----------------+-------------+ 10 rows in set (0.01 sec) mysql> select * from poke10; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 10 rows in set (0.01 sec) mysql> select * from poke5; +-----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +-----------+-----------+--------+--------+----------------+ | Sewaddle | 540 | 3 | 25 | 62 | | Pidove | 519 | 3 | 21 | 53 | | Kricketot | 401 | 3 | 22 | 54 | | Taillow | 276 | 3 | 23 | 59 | | Caterpie | 10 | 3 | 29 | 53 | +-----------+-----------+--------+--------+----------------+ 5 rows in set (0.01 sec) mysql> select * from poke10 p, poke5 s where p.name = s.name; +----------+-----------+--------+--------+----------------+----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | Name | PokedexID | Height | Weight | BaseExperience | +----------+-----------+--------+--------+----------------+----------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | Caterpie | 10 | 3 | 29 | 53 | +----------+-----------+--------+--------+----------------+----------+-----------+--------+--------+----------------+ 1 row in set (0.01 sec) mysql> select * -> FROM poke10 NATURAL JOIN poke5; +----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +----------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | +----------+-----------+--------+--------+----------------+ 1 row in set (0.01 sec) mysql> select count(*) from poke10; +----------+ | count(*) | +----------+ | 10 | +----------+ 1 row in set (0.00 sec) mysql> select * from poke10; +------------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +------------+-----------+--------+--------+----------------+ | Caterpie | 10 | 3 | 29 | 53 | | Blastoise | 9 | 16 | 855 | 210 | | Wartortle | 8 | 10 | 225 | 143 | | Squirtle | 7 | 5 | 90 | 66 | | Charizard | 6 | 17 | 905 | 209 | | Charmeleon | 5 | 11 | 190 | 142 | | Charmander | 4 | 6 | 85 | 65 | | Venusaur | 3 | 20 | 1000 | 208 | | Ivysaur | 2 | 10 | 130 | 141 | | Bulbasaur | 1 | 7 | 69 | 64 | +------------+-----------+--------+--------+----------------+ 10 rows in set (0.00 sec) mysql> select max(height), min(height), avg(height) from poke10; +-------------+-------------+-------------+ | max(height) | min(height) | avg(height) | +-------------+-------------+-------------+ | 20 | 3 | 10.5000 | +-------------+-------------+-------------+ 1 row in set (0.00 sec) mysql> select max(height*100/weight) from poke10; +------------------------+ | max(height*100/weight) | +------------------------+ | 10.3448 | +------------------------+ 1 row in set (0.00 sec) mysql> select max(Name), min(Name), avg(Name) from poke10; +-----------+-----------+-----------+ | max(Name) | min(Name) | avg(Name) | +-----------+-----------+-----------+ | Wartortle | Blastoise | 0 | +-----------+-----------+-----------+ 1 row in set, 10 warnings (0.00 sec) mysql> select max(Name), min(Name), sum(Name) from poke10; +-----------+-----------+-----------+ | max(Name) | min(Name) | sum(Name) | +-----------+-----------+-----------+ | Wartortle | Blastoise | 0 | +-----------+-----------+-----------+ 1 row in set, 10 warnings (0.01 sec) mysql> create table foo (a char(5)); Query OK, 0 rows affected (0.02 sec) mysql> insert into foo values('1'),('2'),('3'); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from foo; +------+ | a | +------+ | 1 | | 2 | | 3 | +------+ 3 rows in set (0.00 sec) mysql> select avg(a) from foo; +--------+ | avg(a) | +--------+ | 2 | +--------+ 1 row in set (0.00 sec) mysql> select sum(a) from foo; +--------+ | sum(a) | +--------+ | 6 | +--------+ 1 row in set (0.00 sec) mysql> select sum(a)*27 - 3*6 from foo; +-----------------+ | sum(a)*27 - 3*6 | +-----------------+ | 144 | +-----------------+ 1 row in set (0.00 sec) mysql> select sum(a)*27 - 3*6 AS expr from foo; +------+ | expr | +------+ | 144 | +------+ 1 row in set (0.00 sec) mysql> select Name, Weight/Height -> from poke10; +------------+---------------+ | Name | Weight/Height | +------------+---------------+ | Caterpie | 9.6667 | | Blastoise | 53.4375 | | Wartortle | 22.5000 | | Squirtle | 18.0000 | | Charizard | 53.2353 | | Charmeleon | 17.2727 | | Charmander | 14.1667 | | Venusaur | 50.0000 | | Ivysaur | 13.0000 | | Bulbasaur | 9.8571 | +------------+---------------+ 10 rows in set (0.01 sec) mysql> select Name, Weight/Height from poke10 -> order by Weight/Height; +------------+---------------+ | Name | Weight/Height | +------------+---------------+ | Caterpie | 9.6667 | | Bulbasaur | 9.8571 | | Ivysaur | 13.0000 | | Charmander | 14.1667 | | Charmeleon | 17.2727 | | Squirtle | 18.0000 | | Wartortle | 22.5000 | | Venusaur | 50.0000 | | Charizard | 53.2353 | | Blastoise | 53.4375 | +------------+---------------+ 10 rows in set (0.00 sec) mysql> select Name, Weight/Height from poke10 order by Weight-Height; +------------+---------------+ | Name | Weight/Height | +------------+---------------+ | Caterpie | 9.6667 | | Bulbasaur | 9.8571 | | Charmander | 14.1667 | | Squirtle | 18.0000 | | Ivysaur | 13.0000 | | Charmeleon | 17.2727 | | Wartortle | 22.5000 | | Blastoise | 53.4375 | | Charizard | 53.2353 | | Venusaur | 50.0000 | +------------+---------------+ 10 rows in set (0.00 sec) mysql> select Name, Weight/Height from poke10 order by BaseExperience - Weight; +------------+---------------+ | Name | Weight/Height | +------------+---------------+ | Venusaur | 50.0000 | | Charizard | 53.2353 | | Blastoise | 53.4375 | | Wartortle | 22.5000 | | Charmeleon | 17.2727 | | Squirtle | 18.0000 | | Charmander | 14.1667 | | Bulbasaur | 9.8571 | | Ivysaur | 13.0000 | | Caterpie | 9.6667 | +------------+---------------+ 10 rows in set (0.00 sec) mysql> select Name, Weight/Height AS Foo from poke10 order by Foo; +------------+---------+ | Name | Foo | +------------+---------+ | Caterpie | 9.6667 | | Bulbasaur | 9.8571 | | Ivysaur | 13.0000 | | Charmander | 14.1667 | | Charmeleon | 17.2727 | | Squirtle | 18.0000 | | Wartortle | 22.5000 | | Venusaur | 50.0000 | | Charizard | 53.2353 | | Blastoise | 53.4375 | +------------+---------+ 10 rows in set (0.01 sec) mysql> select count -> (*) from poke10; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) from poke10' at line 2 mysql> select count (*) from poke10; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) from poke10' at line 1 mysql> select count(*) from poke10; +----------+ | count(*) | +----------+ | 10 | +----------+ 1 row in set (0.00 sec) mysql> select count( Name) from poke10; +--------------+ | count( Name) | +--------------+ | 10 | +--------------+ 1 row in set (0.01 sec) mysql> insert into poke5(PokedexId) values(17); Query OK, 1 row affected (0.01 sec) mysql> select * from pokedexID; ERROR 1146 (42S02): Table 'pokemon.pokedexID' doesn't exist mysql> select * from poke5; +-----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +-----------+-----------+--------+--------+----------------+ | Sewaddle | 540 | 3 | 25 | 62 | | Pidove | 519 | 3 | 21 | 53 | | Kricketot | 401 | 3 | 22 | 54 | | Taillow | 276 | 3 | 23 | 59 | | Caterpie | 10 | 3 | 29 | 53 | | NULL | 17 | NULL | NULL | NULL | +-----------+-----------+--------+--------+----------------+ 6 rows in set (0.00 sec) mysql> select count(*) from poke5; +----------+ | count(*) | +----------+ | 6 | +----------+ 1 row in set (0.00 sec) mysql> select count(Name) from poke5; +-------------+ | count(Name) | +-------------+ | 5 | +-------------+ 1 row in set (0.00 sec) mysql> select count(Height) from poke5; +---------------+ | count(Height) | +---------------+ | 5 | +---------------+ 1 row in set (0.01 sec) mysql> select * from poke5; +-----------+-----------+--------+--------+----------------+ | Name | PokedexID | Height | Weight | BaseExperience | +-----------+-----------+--------+--------+----------------+ | Sewaddle | 540 | 3 | 25 | 62 | | Pidove | 519 | 3 | 21 | 53 | | Kricketot | 401 | 3 | 22 | 54 | | Taillow | 276 | 3 | 23 | 59 | | Caterpie | 10 | 3 | 29 | 53 | | NULL | 17 | NULL | NULL | NULL | +-----------+-----------+--------+--------+----------------+ 6 rows in set (0.00 sec) mysql> select count(DISTINCT height) from poke5; +------------------------+ | count(DISTINCT height) | +------------------------+ | 1 | +------------------------+ 1 row in set (0.00 sec) mysql> exit