Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    7

    Unanswered: possible?: UPDATE (id1,id2) values (val1,val2)

    Well i wanna know if its possible to do something like this:

    Code:
    UPDATE IGNORE `test` SET (id1,id2) values (val1,val2) WHERE name = jonas
    Thanks for reading

    Jonas

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Code:
    UPDATE IGNORE test
      SET id1 = val1, 
          id2 = val2
    WHERE name = 'jonas'
    For more details see the manual:
    http://dev.mysql.com/doc/refman/5.0/en/update.html

Posting Permissions

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