+ 1
Not able to find customers table under mysql. I've logged on to localhost/phpmyadmin server. How to proceed?
3 ответов
+ 2
SELECT * FROM customers;
+ 2
Use the following query to troubleshoot the issue, list databases by using the sql syntax:
SHOW DATABASES;
if mysql exists on the list, the check for its tables. first select the database you want to use:
USE mysql;
then list the tables of mysql database:
SHOW TABLES;
Check if customers table is present, if so query the table:
SELECT * FROM customers;
if you don't see the mysql database at all but you're sure it exists, check the user you used to login in phpmyadmin and make sure it has enough privileges to view the database. if none of the above applies, the customer's table isn't inside mysql database. check the other databases.
0
show costumers;