Professional Web Applications Themes

overwrite/don't overwrite data... - MySQL

hi, how do you prevent MySQL from overwriting data that already exists in a table? i.e., insert into tbpb set page='" + sBlogPg + "', photo='" + i + ".jpg', caption=''; but if, for example, there already exists a 7.jpg for page 1 don't insert that one....;) thank you......

  1. #1

    Default overwrite/don't overwrite data...

    hi,

    how do you prevent MySQL from overwriting data that already exists in a
    table?

    i.e., insert into tbpb set page='" + sBlogPg + "', photo='" + i +
    ".jpg', caption='';

    but if, for example, there already exists a 7.jpg for page 1 don't
    insert that one....;)

    thank you...

    maya Guest

  2. #2

    Default Re: overwrite/don't overwrite data...

    maya wrote: 

    Either you check that first, or you make the page+photo column together to be
    a key.


    --

    //Aho
    J.O. Guest

  3. #3

    Default Re: overwrite/don't overwrite data...

    J.O. Aho wrote: 
    >
    > Either you check that first, or you make the page+photo column together to be
    > a key.[/ref]

    "a key"??? you mean foreign keys?? as in here?
    http://dev.mysql.com/doc/refman/5.0/en/example-foreign-keys.html

    thank you...

    maya Guest

  4. #4

    Default Re: overwrite/don't overwrite data...

    On Fri, 08 Jun 2007 14:43:21 -0400, maya <com>
    wrote:
     
    >>
    >> Either you check that first, or you make the page+photo column together to be
    >> a key.[/ref]
    >
    >"a key"??? you mean foreign keys?? as in here?
    >http://dev.mysql.com/doc/refman/5.0/en/example-foreign-keys.html[/ref]

    Not a foreign key, but a UNIQUE constraint, like primary keys
    implicitly are.
    If you already have a primary key, add a unique index on
    (page,photo) or (photo,page).
     
    --
    ( Kees
    )
    c[_] If you're happy and you know it, clunk your chains. (#137)
    Kees Guest

Similar Threads

  1. Overwrite the O/S ?
    By R. in forum AIX
    Replies: 3
    Last Post: November 1st, 03:20 AM
  2. ok to overwrite MBR?
    By Andre in forum Linux Setup, Configuration & Administration
    Replies: 10
    Last Post: October 28th, 04:50 AM
  3. Overwrite DLL?
    By Qwip in forum ASP
    Replies: 6
    Last Post: October 14th, 02:38 PM
  4. Overwrite
    By Mike Bynum in forum Windows XP/2000/ME
    Replies: 4
    Last Post: July 21st, 11:47 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