show contents

[boogyman]

what's the command to show all the contents of a database?
I would prefer not to use a foreach script and increment the tables, but if that's the best way I guess I could.

[codeexploiter]

Have a look at this page

[boogyman]

that is just telling me how I can select a table within the database, I am looking to view all of the records stored inside the tables. I am attempting to optimize our database and go from the nearly 550 tables to 4. In doing so I understand I am going to have an excessive amount of redundant data, and I wanted to know if there was an easy way to access the records inside of the tables.

or Ideally if there was a script I could use to print out the unique records in which there are multiple field headers that are not uniform across all of the tables.