June 20th, 2013, 07:56 PM
Table schema to paper
Is there an easy and FREE way to print out on paper, or otherwise copy/paste onto a document, my table schema?
June 20th, 2013, 08:08 PM
What sort of representation of the schema do you want to print? MySQL Workbench can do a graphical representation of a schema.
June 20th, 2013, 08:16 PM
I'm just looking for simple table structure:
Field name, Data type, Description.
It looks like phpmyadmin does this through the "data dictionary" link so I may use this if there isn't anything else suitable. Do you have any suggestions of your own?
I'm looking to replace my current method of handwriting and keeping pages of table info.
June 20th, 2013, 09:09 PM
use mysqldump to generate the CREATE TABLE statements
June 21st, 2013, 12:11 PM
r937, I considered this but I decided on a better approach. I'm going to create a small script on my server that will fetch the information I need and generate a nice looking html report on the fly. Then I can just print that out from the browser. It means a little bit of leg work to create the script, but in the end it will look nicer and result in less work for me each time I need to update my reports. Thanks for your comments and help, r937 & E-Oreo.