Forgive me if this is a meta question - if so I'll quickly move it.
I would like to be able to output a table structure in the format often used on SO, so that when I post questions, I don't have to do time consuming reformatting. I've often seen something like this on SO:
+--------------+------------------+
| Field | Type |
+--------------+------------------+
| userid | int(10) |
| firstname | varchar(50) |
| lastname | varchar(50) |
+--------------+------------------+
How do you do it?
I am using phpmyadmin under Windows but don't mind using a mysqldump statement, or even a php script.
Using the statement "Describe table" under phpmyadmin gives the table but obviously not formatted for posting.
Using mysqldump gives me only create statements