Mass edit Database

Discussion in 'MySQL' started by mysoogal, Mar 9, 2009.

0
  1. #1
    i need to change

    owner_id
    1


    to
    owner_id
    10000

    i have about 170 posts which need to be added to Guest Account.

    can someone help me, i know there is mysql command for this but im not sure how to put it all together in the sql window.:eek:
     
    mysoogal, Mar 9, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    execute a query like this
    update tablename set owner_id = '10000'
     
    crivion, Mar 10, 2009 IP
  3. madguy24

    madguy24 Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    update tablename set owner_id = '10000' where owner_id='1' .. won't it be a little more better ?
     
    madguy24, Mar 10, 2009 IP
  4. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #4
    ohh yes my bad
    totally true
     
    crivion, Mar 10, 2009 IP
  5. mysoogal

    mysoogal Guest

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    thanks very much sorry late reply, I've figured it out soon after i posted this message :p
     
    mysoogal, Apr 15, 2009 IP