CODEWITHSUNDEEP
mysqlsqlshow
VyR
VyR

Reputation: 231

select only ONE column from the query: "SHOW TABLE STATUS FROM `DB`"?

is possible select only ONE column from the QUERY: "SHOW TABLE STATUS FROM DB" ??

I want select ONLY 1 or 2 columns from result obtained in the QUERY:

SHOW TABLE STATUS FROM `DB`

I need ALL tables of this DB, but I no need columns as

Max_data_length, Index_length, Data_free, Auto_increment, etc...

is possible get only ONE column from this multiple columns result in only 1 QUERY?

Upvotes: 3

Views: 2046

Answers (1)

Ed Bangga
Ed Bangga

Reputation: 13006

You can query from information_schema.tables instead of showing table status. It will give you same information you need

SELECT TABLE_NAME
  , DATA_LENGTH FROM information_schema.tables WHERE table_schema = DATABASE();

Upvotes: 6

Related Questions