请下载数据,解压后,复制到mysql的data文件夹里面。https://pan.baidu.com/s/1GWKE...mysql> show databases;
+--------------------+| Database |
+--------------------+| information_schema |
| guestbook |
| lyb |
| mysql |
| performance_schema |+--------------------+5 rows in set (0.06 sec)我发现guestbook的数据可以使用。mysql> use lyb;
Database changedmysql> 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>明明存在表格,为何会这样?
添加回答
举报
0/150
提交
取消