mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| PokeStats         |
| Pokemon           |
| Species           |
| Types             |
| foo               |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
+-------------------+
11 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> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| PokeStats         |
| Pokemon           |
| Species           |
| Types             |
| foo               |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
+-------------------+
11 rows in set (0.00 sec)

mysql> select count(*) from PokeStats;
+----------+
| count(*) |
+----------+
|      649 |
+----------+
1 row in set (0.00 sec)

mysql> select * from PokeStats limit 10;
+-----------+-----------+--------+--------+----------------+
| 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 |
+-----------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select * from Species limit 10;
+-----------+--------+-------------+
| PokedexID | TypeID | Genus       |
+-----------+--------+-------------+
|         1 |     12 | Seed        |
|         2 |     12 | Seed        |
|         3 |     12 | Seed        |
|         4 |     10 | Lizard      |
|         5 |     10 | Flame       |
|         6 |     10 | Flame       |
|         7 |     11 | Tiny Turtle |
|         8 |     11 | Turtle      |
|         9 |     11 | Shellfish   |
|        10 |      7 | Worm        |
+-----------+--------+-------------+
10 rows in set (0.00 sec)

mysql> select * from Types;
+--------+----------+------------+-------------+
| TypeID | Type     | Generation | DamageClass |
+--------+----------+------------+-------------+
|      1 | normal   |          1 |           2 |
|      2 | fighting |          1 |           2 |
|      3 | flying   |          1 |           2 |
|      4 | poison   |          1 |           2 |
|      5 | ground   |          1 |           2 |
|      6 | rock     |          1 |           2 |
|      7 | bug      |          1 |           2 |
|      8 | ghost    |          1 |           2 |
|      9 | steel    |          2 |           2 |
|     10 | fire     |          1 |           3 |
|     11 | water    |          1 |           3 |
|     12 | grass    |          1 |           3 |
|     13 | electric |          1 |           3 |
|     14 | psychic  |          1 |           3 |
|     15 | ice      |          1 |           3 |
|     16 | dragon   |          1 |           3 |
|     17 | dark     |          2 |           3 |
|  10001 | unknown  |          2 |        NULL |
|  10002 | shadow   |          3 |        NULL |
+--------+----------+------------+-------------+
19 rows in set (0.00 sec)

mysql> create table SpTypes as (SELECT * from Species s, types t where
    -> s.TypeID = t.TypeId);
ERROR 1146 (42S02): Table 'pokemon.types' doesn't exist
mysql> create table SpTypes as (SELECT * from Species s, Types t where s.TypeID = t.TypeId);
ERROR 1060 (42S21): Duplicate column name 'TypeID'
mysql> create table SpTypes as (SELECT * from Species s, Types t where s.TypeID = t.Type);
ERROR 1060 (42S21): Duplicate column name 'TypeID'
mysql> create table SpTypes as (SELECT * from Species s, Types t where s.TypeID = t.TypeId);
ERROR 1060 (42S21): Duplicate column name 'TypeID'
mysql> 
mysql> create table SpTypes as (SELECT s.*, t.type  from Species s, Types t where s.TypeID = t.TypeId);
Query OK, 649 rows affected (0.02 sec)
Records: 649  Duplicates: 0  Warnings: 0

mysql> select * from SpTypes limit 10;
+-----------+--------+-----------+--------+
| PokedexID | TypeID | Genus     | type   |
+-----------+--------+-----------+--------+
|        16 |      1 | Tiny Bird | normal |
|        17 |      1 | Bird      | normal |
|        18 |      1 | Bird      | normal |
|        19 |      1 | Mouse     | normal |
|        20 |      1 | Mouse     | normal |
|        21 |      1 | Tiny Bird | normal |
|        22 |      1 | Beak      | normal |
|        35 |      1 | Fairy     | normal |
|        36 |      1 | Fairy     | normal |
|        39 |      1 | Balloon   | normal |
+-----------+--------+-----------+--------+
10 rows in set (0.01 sec)

mysql>