Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to display table status with specific columns?

Status
Not open for further replies.
alan123

alan123

MIS
Oct 17, 2002
149
US
For mysql, "show table status" displays all table information such as NAME, TYPE, ROW_FORMAT, ROWS.....
How can I only display certain columns(not display all), for example only shows NAME, ROWS?
 
Sort by date Sort by votes
How are you displaying the data...thru php or some gui?

Bastien

Cat, the other other white meat
 
Upvote 0 Downvote
Its returned as a recordset, you can specify which columns to echo out with php...

Bastien

Cat, the other other white meat
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
218
Chris Miller
Chris Miller
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
294
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
275
lupidol
lupidol
AbidingDude
  • Locked
  • Question
One Constraint for Multiple Columns 1
Replies
2
Views
170
AbidingDude
AbidingDude
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
214
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top