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>