Search This Blog

Mar 7, 2013

Exporting Database Table Schema to Excel / CSV Format

In exporting database table schema, I highly recommend the mysql query browser tool. It allows you to export your table schema in csv, html, xml, excel and plist (property list) file format. Aside from that, It also gives you a complete set of drag-and-drop tools to visually build, analyze and manage your db queries. I like it compare to Navicat or Mysql toad in terms of handling database schema simply because of simplicity.

Here are the steps on how to export table schema using mysql query browser. 

1. Run the mysql browser query application, login and choose the database you want to use.

2. Write this sql command “desc table_name;” in the query field and hit execute button.

3. Right after hitting the execute button you will be able to see the list. Hit the “File” menu link at the top, then choose Export ResultSet. Choose the format you like and you’re good to go.