Search
Left Quote    A clever person solves a problem. A wise person avoids it.
- Einstein    
Right Quote
 
[login] | [Register]
Forum Index » PHP and mySQL » Viewing Topic and Replies
Post Reply


        Viewing Topic: columns in a table - sql
  This user is offline  David1159
  Subject: "columns in a table - sql" Posted: @ 10:42 pm on Mar 28 2008   

Member #: 526
Rank: User - (81)
Since: 12/27/07
Posts: 81
From: usa

Is it bad to have a lot of columns in one table of SQL? Is there a limit?

My current table has 8 columns, but there will most likely be 100 columns. All of these will constantly be updating too.

I just would like to know if it is bad, if it is I am going to divide them by categories.

Actually the more I'm thinking, the more I better divide them.

Edited at 10:49:54 pm on 03/28/08


Coding is simply CST... Combining $hit Together. We make different $hit to run in unison correctly.
    Viewed: 3,775 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: columns in a table - sql" Posted: @ 1:12 am on Mar 29 2008    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

The first thing that is coming to my mind is Database Normalization. Have a read, it maybe the answer you're looking for.




-bs0d | AllSyntax.com

    Viewed: 3,768 Times | Reply to This | To top
Viewing Page: 1 of 1


1 |

You must be logged in to post on the forums. Login or Register








"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank