Professional Web Applications Themes

error when insert an already existing entry - MySQL

Hello, when my application wants to insert a row which is already in the table there is an error message, ok. But how can I do it that the old one will be overwritten or nothing happens and the rest of the sql-statement is executed? at the moment my statement looks like this: insert into cbc_survey(ticketnr) (SELECT ticketno FROM ticket t,global g where state = 'xx' and ..); thank u very much. best regards, Dennis...

  1. #1

    Default error when insert an already existing entry

    Hello,

    when my application wants to insert a row which is already in the table
    there is an error message, ok.
    But how can I do it that the old one will be overwritten or nothing happens
    and the rest of the sql-statement is executed?

    at the moment my statement looks like this:

    insert into cbc_survey(ticketnr)
    (SELECT ticketno FROM ticket t,global g
    where state = 'xx'
    and ..);

    thank u very much.

    best regards,

    Dennis


    Dennis Guest

  2. #2

    Default Re: error when insert an already existing entry


    Dennis Kuntzemann wrote: 

    REPLACE INTO will delete the old record and replace it with the new
    one.
    INSERT ... ON DUPLICATE KEY UPDATE will retain the original record and
    update whatever fields you specify.

    Captain Guest

Similar Threads

  1. Insert/Paste an image into an existing PDF?
    By kristin_maling@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 9
    Last Post: September 25th, 11:38 PM
  2. Procedure Entry Point error
    By joerockhead in forum Macromedia Contribute Connection Administrtion
    Replies: 1
    Last Post: January 30th, 05:53 AM
  3. insert record page - want to see the entry
    By I Need Help! in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 12th, 10:37 PM
  4. Entry point ThunkConnect Kernel32.dll ERROR
    By kenaeverman in forum Adobe Photoshop Elements
    Replies: 9
    Last Post: September 3rd, 10:47 PM
  5. Any ideas on how to confirm data entry of an item post entry?
    By Dale C Gray in forum Microsoft Access
    Replies: 3
    Last Post: July 21st, 03:40 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