Skateboarding - Paid Surveys - Home Loan - Credit Cards - Flights

PDA

View Full Version : Print MySQL Table Fields


obenix
Sep 6th 2005, 3:23 am
How do I print out the fields and it's related attributes from tables in MySQL?
I use MySQL Control Center but I see no print function...:(

noppid
Sep 6th 2005, 3:24 am
show create table <table_name>;

T0PS3O
Sep 6th 2005, 3:24 am
Print as in on Paper? Or print as in the PHP function print etc?

obenix
Sep 6th 2005, 3:26 am
Print as in on Paper? Or print as in the PHP function print etc?
Print as in print on a piece of paper..:p

T0PS3O
Sep 6th 2005, 3:29 am
I forgot how paper even looks like so I don't have a clue :)

Welcome to the digital era!

obenix
Sep 6th 2005, 3:32 am
I forgot how paper even looks like so I don't have a clue :)

Welcome to the digital era!
Yeah... My eyesight is not getting any better from reading from the screen..:D
I dislike having to toggle my screen from PHP programming and MySQL...
I thought I might as well print out a copy and stick it on the wall...

noppid
Sep 6th 2005, 7:59 am
Here's a novel idea.

Dump the table structure.
Copy and paste to your favorite editor.
Click the "print" icon.

Liminal
Sep 8th 2005, 9:06 am
1) Connect to your server
2) Issue command: describe <your-table-name>;

Alternatively, use phpMyAdmin if you have access to it. I don't think their MySQL Control Center can do it