Professional Web Applications Themes

stuck with SQL query, could someone help? - MySQL

I have one table with two columns (code and value). I need to write insert a new record into this table, but only if it doesn't the same code as old records. I am not much familiar with IF, IF EXITS, CASE and other statements. Maybe something like, this: (but this one doesn't work completely) IF NOT EXISTS (SELECT code FROM `files` WHERE code = 'g') BEGIN INSERT INTO `files_log` (code, value) VALUES ('g', '2500') END Thanks for help, I really appreciate it....

Sponsored Links
  1. #1

    Default stuck with SQL query, could someone help?

    I have one table with two columns (code and value). I need to write
    insert a new record into this table, but only if it doesn't the same
    code as old records.

    I am not much familiar with IF, IF EXITS, CASE and other statements.
    Maybe something like, this: (but this one doesn't work completely)

    IF NOT EXISTS (SELECT code FROM `files` WHERE code = 'g')
    BEGIN
    INSERT INTO `files_log` (code, value) VALUES ('g', '2500')
    END

    Thanks for help, I really appreciate it.

    Sponsored Links
    david Guest

  2. #2

    Default Re: stuck with SQL query, could someone help?

    On 4 Jul, 12:00, david <com> wrote: 

    Just make `code` a unique key, then mysql will reject the insert if it
    already exists.

    Captain Guest

  3. #3

    Default Re: stuck with SQL query, could someone help?

    On 4 Jul, 12:00, david <com> wrote: 

    Hold on, I just noticed, you are checking a table called `files` but
    writing to `files_log`???

    Please explain?

    Captain Guest

  4. #4

    Default Re: stuck with SQL query, could someone help?

    Ops... :) I think I need to get some rest.
    Hm...

    david Guest

Similar Threads

  1. CFC Query - stuck, stuck, stuck
    By Howard Perlman in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: July 7th, 02:56 PM
  2. stuck with SQL
    By Jeff Shapiro in forum PHP Development
    Replies: 0
    Last Post: August 30th, 04:14 PM
  3. php.. Am I stuck??
    By No in forum PHP Development
    Replies: 1
    Last Post: August 20th, 07:23 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