请下载数据,解压后,复制到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>
明明存在表格,为何会这样?
相关分类