How to get table structure at a time for many?

Question

I have a MySQL database say test. It contains 10 tables. I know I can do describe <table_name> to get skeleton of that table. But I have to do that for each table individually.

This is my problem. Any query or script I can write to get the skeleton of all those tables at time?

http://stackoverflow.com/questions/193780/how-to-find-all-the-tables-in-mysql-with-specific-column-names-in-them try this — spaceman, Jan 21 '14 at 07:59

score 1 · Accepted Answer · answered Jan 21 '14 at 08:05

1

Try Like this

SELECT * FROM information_schema.columns Where TABLE_SCHEMA='test';

answered Jan 21 '14 at 08:05

Vignesh Kumar A

26,868
11
59
105

Thanks vignesh. can you help me with how to save output to a excel sheet ? – rɑːdʒɑ Jan 21 '14 at 08:26
1

@rajagenupula: You should better post a new query for answer on db to excel. – Ravinder Reddy Jan 21 '14 at 08:31
http://stackoverflow.com/questions/21253704/how-to-save-mysql-queryu-output-to-excel-or-txt-file – rɑːdʒɑ Jan 21 '14 at 09:15
@rajagenupula I have posted answer there in the name of Vignesh Kumar .please check it – Vignesh Kumar A Jan 21 '14 at 09:17

Palec · Answer 2 · 2014-01-21T08:35:38.643

0

mysqldump can be told to skip data and dump only table schema.

mysqldump --no-data test

Use options -u <user> to connect as <user> and -p to ask for password. Maybe you also want --compact to be less verbose and possibly other. Many adjustments to the contents can be made using other options.

edited Jan 21 '14 at 08:35

answered Jan 21 '14 at 08:11

Palec

11,499
7
57
127

How to get table structure at a time for many?

2 Answers2