MySQL schema to Excel

[DavidRock]

Hello,

How can I export a MySQL schema into a tabular report that can be imported into Excel, etc? I want columns with field name, type, length, etc. horizontally. I don't want data, just schema.

Thanks,
David Rock

 

[sleipnir214]

Without having to modify the information coming out of MySQL? Probably not -- MySQL and Access have different names for column types, etc.


It's possible to get MySQL to tell you the SQL necessary to recreate a database or table. Look at the MySQL online manual entry for SHOW CREATE TABLE. You can get that data, modify it for changes to column-type names and other things, then run the queries in Access.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[TonyGroves]

You can use SHOW COLUMNS FROM tblname for each table.


-----
ALTER world DROP injustice, ADD peace;

 

[DavidRock]

Thanks TonyGroves - showcolums does what I'm looking for.