#1
  1. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Is there a recommended size (# of columns) to a given database table?

    I'm really just curious, I understand the
    concept of normalization and the one to many scenario.

    But, in some cases.. is it just a good idea to split a table into multiple tables, after so many columns?

    Last question--

    HTML in a database table.. should HTML be encoded? Granted, I've inserted URL's without a problem, and I've noticed that "'" single quotes need be processed with the before it... I'm just wondering about other
    HTML related character's that may present problems?

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    14
    Rep Power
    0
    There is no recommended set number of columns in a table, just whatever is needed to describe your data.
    It could be as simple as a few or as many as a couple of dozen.
    You should look into the welath of internet articles on database design.

    Group related sets of data into individual tables, with a common column so they can be related.

    html code is plain text. It depends on the special characters you need to escape with the escape character such as backslant. You can specifically which ones and how to handlw them at the following link: http://www.mysql.com/documentation/m....html#Literals

    the part you want reads as follows:
    Within a string, certain sequences have special meaning. Each of these sequences begins with a
    backslash (`'), known as the escape character. MySQL recognizes the following escape
    sequences:

    An ASCII 0 (NUL) character.
    n A newline character.
    t A tab character.
    r A carriage return character.
    b A backspace character.
    ' A single quote (`'') character.
    " A double quote (`"') character.
    A backslash (`') character.
    % A `%' character. This is used to search for literal instances of `%' in contexts where `%'
    would otherwise be interpreted as a wildcard character. See section 7.4.6 String comparison
    functions.
    _ A `_' character. This is used to search for literal instances of `_' in contexts where `_'
    would otherwise be interpreted as a wildcard character. See section 7.4.6 String comparison
    functions.

    ------------------

Similar Threads

  1. About a table size
    By goreXP in forum Firebird SQL Development
    Replies: 1
    Last Post: November 18th, 2003, 03:21 PM
  2. hash table size limit
    By aof101 in forum MySQL Help
    Replies: 2
    Last Post: August 13th, 2003, 09:52 PM
  3. Getting mysql table size?
    By Saus in forum PHP Development
    Replies: 4
    Last Post: June 20th, 2003, 01:26 PM
  4. Replies: 0
    Last Post: January 31st, 2002, 12:53 PM
  5. table size ?
    By netidev in forum MySQL Help
    Replies: 3
    Last Post: January 15th, 2002, 08:03 PM

IMN logo majestic logo threadwatch logo seochat tools logo