Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: update column using condition

    I want to update a column using as follow

    Table structure

    Table name=A
    a1 varchar( contains Name)
    b1 varchar(require code from d1 where a1 matches with c1)
    c1 varchar(contains Name)
    d1 varchar(code corressponding to c1)

    Now i want to update b1 as such where value a1 =c1 then corressponding value should be updated

    How can we do ?

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    This is a link to a description of the MySQL update statement - have a look at how to use the where clause. It's amazing how useful it can be.

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •