Visual table representation to assist asking for help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Stryks
Forum Regular
Posts: 746
Joined: Wed Jan 14, 2004 5:06 pm

Visual table representation to assist asking for help

Post by Stryks »

Hey all, just wondering if anyone can tell me how people manage to get a nice looking ascii table display to post in these forums.

I often want to show how I'm working my tables when I have a problem and I'm always at a loss for how to show it.

Also, what do you guys prefer in regards to being able to understand someone elses database? An ascii representation or an SQL table creation script?

Cheers.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I prefer SQL. A lot of the questions I deal with involve needing to know the table structure.

phpMyAdmin has an "export" feature that creates a SQL file with a combination of structure and data, along with ancillary things.

It's nice to get a few records as well, so I have something to test against when I'm testing a query or something..
Post Reply