What is the SQL query to change data in field in a MySQL DB?

Discussion in 'Databases' started by webber98, Dec 1, 2009.

  1. #1
    Not very experienced in databases. How can I directly change the data in a field using phpMyAdmin. I have the window open to change the area I want, but I don't know the sql query. Here's the details:

    SELECT * FROM `users`

    and say the field is called 'description' and the new data I want in there is 'xyz'


    thanks.
     
    webber98, Dec 1, 2009 IP
  2. tfraymond

    tfraymond Active Member

    Messages:
    27
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    68
    #2
    in phpMyAdmin, just click on the little pencil to the left of the record you want to edit, make the changes in the form you see, and click the 'go' button. That's it.
     
    tfraymond, Dec 1, 2009 IP
  3. webber98

    webber98 Peon

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    wow. i was hoping it was going to be easy, but i had no idea. thanks tom. that was fantastic - it worked perfectly. thanks so much!
     
    webber98, Dec 1, 2009 IP
  4. ISellMyITKnowledge

    ISellMyITKnowledge Peon

    Messages:
    55
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hello !

    by the way you can do that by executing a query as well ;) it's not so easy as just changing data but it shure will help you in future like you cannot always go on DB and change records but you can just update your info ! :) PM if you need visual tutorials on this i cannot post links yet :/ !
     
    ISellMyITKnowledge, Dec 2, 2009 IP