Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    New Delhi, India.
    Posts
    9

    Unanswered: update query to be corrected...

    how do i get the following update query to work in MySQL?

    UPDATE CONTACT_DETAIL SET
    ADDRESS_1 = 'ADDRESS_1',
    ADDRESS_2 = 'ADDRESS_2',
    CITY = 'CITY',
    STATE = 'NJ',
    ZIP = '11111',
    PHONE = '1231231231',
    EXTENSION = '123',
    FAX = '1231231231',
    MOBILE = '123123123',
    EMAIL = 'mail@ccc.com',
    ROW_VERSION = ROW_VERSION + 1,
    name = 'username'
    WHERE CONTACT_DETAIL.CONTACT_ID = (SELECT CONTACT_ID FROM USERS WHERE USER_ID = 1)

    thanks
    Sham

  2. #2
    Join Date
    Feb 2002
    Location
    New Delhi, India.
    Posts
    9
    sorry i missed telling that am using MySQL version 3.23.54.

    Thanks again...
    Sham

Posting Permissions

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