Page 1 of 1

Retreiving all tablenames

Posted: Sun Aug 20, 2006 5:57 pm
by Shendemiar
Is there a way to query list of tablenames from mysql?

Posted: Sun Aug 20, 2006 5:58 pm
by RobertGonzalez

Code: Select all

SHOW TABLES;

Posted: Sun Aug 20, 2006 6:04 pm
by Shendemiar
Everah wrote:

Code: Select all

SHOW TABLES;
Thanks...

I find the MySql website and manual very difficult to use thus unhelpful.

Posted: Sun Aug 20, 2006 6:10 pm
by RobertGonzalez
I did too at first. But once you start learning how it is set up, you start figuring out how to ask it questions.

PS phpMyAdmin is a great way to learn some useful queries as it relates to your mysql server.