-1

Blockquote

sir i want to fetch all the table's name and information about all table as total no. of field etc with the help of single query in php file .i am using phpmyadmin as mysql please tell me how can i do it.

thanks

user3168996
  • 1

1 Answers1

1
select * from information_schema.TABLES

You can also check :

select * from information_schema.COLUMNS
Loïc
  • 11,804
  • 1
  • 31
  • 49