Results 1 to 2 of 2

Thread: MySQL Query

  1. #1

    MySQL Query


    I need a little help for a MySQL Query ...

    I would like to update an IP from a table called account_details from 64.246.50.XX to 67.15.159.XX but only when the domain column from client_package start with the letter "a".

    I tried the following query:

    update account_details a set a.ip='67.15.159.XX' where a.ip='64.246.50.XX' and a.client_id in (select p.client_id from client_package p where p.domain like 'a%')

    But got an error:

    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.client_id from client_package p where p.domain like 'a

    Thank you very much
    Dedicated Servers, Managed OpenStack Cloud, Colocation and Managed Colocation in Brazil
    Privately owned 10,000 server capacity Data Center

  2. #2
    Join Date
    Dec 2001

    You should probably ask this in:

    You will get a quick response

    Experienced OpenStack Admin For Hire
    regular as admin0 on freenode IRC on #openstack and #openstack-ansible channels

Posting Permissions

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