Please download the data, extract it, and copy it to the data folder of mysql.
https://pan.baidu.com/s/1GWKE.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| guestbook |
| lyb |
| mysql |
| performance_schema |
+--------------------+
5 rows in set (0.06 sec)I found that guestbook"s data is available.
mysql> use lyb;
Database changed
mysql> show tables;
+---------------+
| Tables_in_lyb |
+---------------+
| admin |
| author |
| cart |
| city |
| link |
| lyb |
| lyb1 |
| messages |
| news |
| province |
| route |
| shop |
+---------------+
12 rows in set (0.00 sec)
mysql> select * from admin;
ERROR 1146 (42S02): Table "lyb.admin" doesn"t exist
mysql> select class from lyb;
ERROR 1146 (42S02): Table "lyb.lyb" doesn"t exist
mysql>it is clear that there is a table, why is this so?