Professional Web Applications Themes

update statement - MySQL

Anyone knows what's the equivalent statement I can use in mysql: update table1 set colA = (select codeA from table2 where codeB=table1.colB) Thanks and best regards....

  1. #1

    Default update statement

    Anyone knows what's the equivalent statement I can use in mysql:

    update table1 set colA = (select codeA from table2 where
    codeB=table1.colB)

    Thanks and best regards.

    Iman Guest

  2. #2

    Default Re: update statement

    UPDATE table1
    LEFT JOIN table2 ON table1.ColB = table2.CodeB
    SET table1.ColA = table2.CodeA
    WHERE table2.CodeB IS NOT NULL;

    Iman wrote: 

    peterloh@gmail.com Guest

  3. #3

    Default Re: update statement

    UPDATE table1
    LEFT JOIN table2 ON table1.ColB = table2.CodeB
    SET table1.ColA = table2.CodeA
    WHERE table2.CodeB IS NOT NULL;

    Iman wrote: 

    peterloh@gmail.com Guest

  4. #4

    Default Re: update statement

    Hi Peter,

    Appreciate if you can let me know which version of mysql that support
    your sql statement.

    com wrote: [/ref]

    Iman Guest

  5. #5

    Default Re: update statement

    In article <googlegroups.com>,
    says... 
    >
    > UPDATE table1
    > LEFT JOIN table2 ON table1.ColB = table2.CodeB
    > SET table1.ColA = table2.CodeA
    > WHERE table2.CodeB IS NOT NULL;[/ref]

    Instead of checking table2.CodeB IS NOT NULL;, why not just use an INNER
    JOIN?

    UPDATE table1
    INNER JOIN table2 ON table1.colB = table2.CodeB
    SET table1.ColA = table2.CodeA;
    --
    PleegWat
    Remove caps to reply
    PleegWat Guest

  6. #6

    Default Re: update statement

    In article <googlegroups.com>, Iman
    says... [/ref][/ref]

    Multi-table updates are supported starting MySQL 4.0.4

    --
    PleegWat
    Remove caps to reply
    PleegWat Guest

Similar Threads

  1. sql - statement for update - id
    By pilem17 in forum Coldfusion Database Access
    Replies: 5
    Last Post: October 3rd, 06:15 AM
  2. update statement with checkboxes
    By happycrack in forum Dreamweaver AppDev
    Replies: 2
    Last Post: June 30th, 09:13 AM
  3. Generated Update Statement
    By Matt M. in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 30th, 04:41 PM
  4. update statement
    By John Bell in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: August 9th, 08:25 PM
  5. Update and Select Statement
    By hngo01 in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 01:32 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