Hello Guys,
I used to get all the table name in ORACLE database by using the following statment:

SELECT * FROM TAB;

But I don't know how to do it in MySQL database. I tried to use the same statment but unfortunately I am getting an error.
So anyone can tell me how can I get the table names from MySQL database?


Regards
Bassam

Use Show tables;
But u must selec the database first in which u want to see the tables