Hello. On Tue 2002-12-10 at 05:59:00 -0800, [EMAIL PROTECTED] wrote: > 2 questions... > > My tutorial db has a number of tables in it... some > with data... some with no records. > > 1 - How can I ask MySQL to tell me the number of > records in my tables? > ..a) all at once? Meaning one command to list... > tbl_1 6 records > tbl_2 3 records > tbl_3 0 records > etc
Have a look at SHOW TABLE STATUS http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html > ..b) one table at a time? Meaning one command per tbl Have a look at the LIKE clause of SHOW TABLE STATUS > 2 - How can I dump the contens of _all_ tables to the > screen or to a text file? Have a look at the command line tool mysqldump: mysqldump your_database > some_file.dump HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php