Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Unanswered: Counting Tables and Columns

    In Oracle, you can count the total number of tables and even the total numbers of columns.

    I don't believe that MySQL has the same abilities, but does anyone have any useful scripts that does the same thing or point me to any websites with such scripts?

    Cheers,

    Kam-Wing Pang

  2. #2
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    You maybe able to write a MySQL shell script that will list the tables, pipe this into memory or a file and then use something like awk to do the counting ???? (I'm not realy sure how though)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •