Results 1 to 2 of 2

Thread: MySQL Query

  1. #1

    MySQL Query

    Hello,

    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
    maxihost.com.br/en
    +1-844-243-9907

  2. #2
    Join Date
    Dec 2001
    Location
    Netherlands
    Posts
    780
    Hi,

    You should probably ask this in: http://www.webhostingtalk.com/forumd...?s=&forumid=37

    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
  •