mysql display all table values and everything in tables

SELECT * FROM INFORMATION_SCHEMA.TABLES
displays all the tables

i would like a command that displays all the tables and all the fields in the tables
LVL 1
rgb192Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
profyaCommented:
You need to run many queries to get the information you need. This link helps: http://www.razorsql.com/articles/mysql_admin_queries.html
0
 
profyaCommented:
You can customize this query I made:

SELECT T.TABLE_NAME, C . *
FROM information_schema.TABLES T
INNER JOIN information_schema.COLUMNS C ON T.TABLE_NAME = C.TABLE_NAME
WHERE T.TABLE_SCHEMA <> 'mysql'

Open in new window

0
 
profyaCommented:
TABLE_SCHEMA represents the database name, you can specify it for a specific database.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
profyaCommented:
This idea also may help:

    Select OBJECT_TYPE,OBJECT_NAME
    FROM
    (
    Select 'TABLE' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
    Union
    Select 'VIEW' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
    Union
    Select 'INDEX[Type:Name:Table]' as OBJECT_TYPE, concat(CONSTRAINT_TYPE,' : ',CONSTRAINT_NAME,' : ',TABLE_NAME) as OBJECT_NAME,TABLE_SCHEMA AS OBJECT_SCHEMA from information_schema.TABLE_CONSTRAINTS
    Union
    Select 'Procedure/Functions' as OBJECT_TYPE, ROUTINE_NAME as OBJECT_NAME, ROUTINE_SCHEMA as OBJECT_SCHEMA from information_schema.ROUTINES
    ) R
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
rgb192Author Commented:
SELECT T.TABLE_NAME, C . *
FROM information_schema.TABLES T
INNER JOIN information_schema.COLUMNS C ON T.TABLE_NAME = C.TABLE_NAME
WHERE T.TABLE_SCHEMA <> 'mysql'

this query finds the table info for all the databases.. thanks...

could you find the data in the columns for one database
for example  (firstname, lastname, email)
i want to see (bob, smith, bobsmith@aol.com)
                      (mary, smith, marysmtih@aol.com)
0
 
profyaCommented:
This is another question man ;)
0
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.