I had a problem with getting the list of the tables in a mysql db.
MySQL 5.0 offers Views so the usual
SHOW TABLES
is not accurate
Used this to get the tables alone
SHOW FULL TABLES WHERE Table_type = ‘BASE TABLE’Â
I had a problem with getting the list of the tables in a mysql db.
MySQL 5.0 offers Views so the usual
SHOW TABLES
is not accurate
Used this to get the tables alone
SHOW FULL TABLES WHERE Table_type = ‘BASE TABLE’Â