Wednesday, December 7, 2011

show mysql database all tables

mysql> show table status from pubccc;
at

2 comments:

  1. Tech NotesJanuary 5, 2012 at 12:28 PM

    select TABLE_NAME, TABLE_ROWS from information_schema.tables where TABLE_SCHEMA='yourdb';

    ReplyDelete

Subscribe to: Post Comments (Atom)