Professional Web Applications Themes

updating all columns - MySQL

I have a 5.1 database where one table has many columns. Is there a way to update all the columns in a row without specifying every column identifier? I've looked at "UPDATE" and "INSERT ... ON DUPLICATE KEY UPDATE", but neither seem to be quite what I'm looking for. Robert Huff...

  1. #1

    Default updating all columns

    I have a 5.1 database where one table has many columns.
    Is there a way to update all the columns in a row without specifying
    every column identifier? I've looked at "UPDATE" and "INSERT ... ON
    DUPLICATE KEY UPDATE", but neither seem to be quite what I'm looking for.


    Robert Huff
    Robert Guest

  2. #2

    Default Re: updating all columns

    Robert Huff <com> wrote:
     

    Nasty, nasty: REPLACE INTO... If you're using a primary ID, this will
    actually delete the row with that ID, and insert a new one with that ID.
    Any constraints may be checked and/or cascaded AFAIK. I'm actually very
    against this kind of 'update'. Also, specifying column names is a good
    thing. It will save you loads of debugging when for instance it's decided
    there should be a field more or less in a table.

    --
    Rik Wasmus
    Posted on Usenet, not any forum you might see this in.
    Ask Smart Questions: http://tinyurl.com/anel
    Rik Guest

  3. #3

    Default Re: updating all columns

    Rik wrote:
     

    Fully aware of that. However:
    a) this is a one-shot cirstance where it's not an unreasonable
    technical choice, and
    b) it's not entirely my call.


    Robert Huff


    Robert Guest

Similar Threads

  1. Replies: 3
    Last Post: June 6th, 10:56 AM
  2. Updating AI Files causes position to 'bounce' when updating in Quark
    By Chris_Tod@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 1
    Last Post: May 6th, 07:29 PM
  3. Updating LONG data type columns
    By Dave in forum Oracle Server
    Replies: 4
    Last Post: November 20th, 12:26 AM
  4. Columns and Inherited Datagrid...Active Schema does not support columns
    By rob thomson in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: September 4th, 03:09 PM
  5. Replies: 0
    Last Post: July 2nd, 06:18 AM

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