How many columns are in YOUR table?

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

Moderator: General Moderators

On average, how many columns are in your main MySQL tables?

Poll ended at Sat Feb 11, 2006 5:38 am

<10
6
33%
10-25
10
56%
25-50
1
6%
50-100
1
6%
100-500
0
No votes
>500
0
No votes
 
Total votes: 18

User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post by neophyte »

I once did an form that had about 70 fields in it. I put them all in one table. It was a one time record for a single individual.
aybra
Forum Commoner
Posts: 56
Joined: Sun Nov 24, 2002 12:52 am

Post by aybra »

typically if i have a data base with over 15 in it, i find myself putting the info into 2.. or 3.. or 6... nothing i've written to date required more than 15.. altho i did make one that ran 3 databases with about.. 13 in each, it was for my wifes daycare, and it had a really nifty looking flash front end, php back end.. and mysql super back end.
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

I don't get an award for having the table with the most columns???

Image
Post Reply