Professional Web Applications Themes

Storing large amounts of data in one field - MySQL

I have a Cold Fusion front end where I want to populate a MySql database with archive information. The front end puts in status and I then copy the old status to a latest history field. Then if the status gets updated it does the same thing but the history info is deleted. Now I want to add an archive field to be able to keep appending so I can keep all of the history. UPDATE theTable SET archive = "archive" "lastesthistory", lastesthistory = "status", status = "form.status" WHERE projId = projID Please advise because the above sql is not ...

  1. #1

    Default Storing large amounts of data in one field

    I have a Cold Fusion front end where I want to populate a MySql
    database with archive information.
    The front end puts in status and I then copy the old status to a latest
    history field. Then if the status gets updated it does the same thing
    but the history info is deleted.


    Now I want to add an archive field to be able to keep appending so I
    can keep all of the history.


    UPDATE theTable
    SET archive = "archive" "lastesthistory",
    lastesthistory = "status",
    status = "form.status"
    WHERE projId = projID


    Please advise because the above sql is not working.

    Also what is the data type I should use for my archive field to store
    all my historical information? I want to use the biggest data type
    available in MySql.
    Each record will be updated once a week and I have about 150 records.

    Please advise.

    teser3@hotmail.com Guest

  2. #2

    Default Re: Storing large amounts of data in one field

    <teser3hotmail.com> wrote in message
    news:1141957667.972564.38380i40g2000cwc.googlegro ups.com...
    > UPDATE theTable
    > SET archive = "archive" "lastesthistory",
    > lastesthistory = "status",
    > status = "form.status"
    > WHERE projId = projID
    >
    > Please advise because the above sql is not working.
    String concatentation in MySQL is done with the CONCAT() function by
    default.
    See [url]http://dev.mysql.com/doc/refman/5.0/en/string-functions.html[/url]

    You can also set the ANSI SQL mode and make it use the double-pipe symbol ||
    for string concatenation, if you prefer syntax compliant with the ANSI
    standard. See PIPES_AS_CONCAT in
    [url]http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html[/url]
    > Also what is the data type I should use for my archive field to store
    > all my historical information? I want to use the biggest data type
    > available in MySql.
    LONGTEXT can store up to 4GB of data in a single field.
    See [url]http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html[/url]

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. Retrieving large amounts of data
    By cqprod in forum Coldfusion Database Access
    Replies: 5
    Last Post: November 3rd, 02:42 PM
  2. PHP Storing compressed data in mssql image field
    By Marcel in forum PHP Development
    Replies: 2
    Last Post: December 11th, 09:38 AM
  3. fitting large amounts of data onto CDs
    By lvirden@yahoo.com in forum Sun Solaris
    Replies: 0
    Last Post: July 18th, 02:24 PM
  4. Replies: 1
    Last Post: July 13th, 04:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139