Find the answer to your Linux question:
Results 1 to 2 of 2
Hello, First of all thank you for taking your time helping me. I can't get this solved :/ i.imgur. com/KFEsL.png I want to update the DB with the information i ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined! Senethic's Avatar
    Join Date
    Oct 2012
    Location
    Netherlands
    Posts
    24

    Exclamation SSH MySQL Won't update userDB


    Hello,

    First of all thank you for taking your time helping me.
    I can't get this solved :/

    i.imgur. com/KFEsL.png

    I want to update the DB with the information i have given.
    Yet it doesn't work.


    Regards,

    Senethic

  2. #2
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,353
    Hello and welcome!

    You need to use the SET command on a table, not a database name. But you need to specify the database name first. Try this mysql statement to connect to the right db:

    Code:
    mysql> use Cyberuben_
    then try your update command, e.g.:
    Code:
    mysql> update $TABLE_NAME set Host='blah';
    you can amend that command to be conditional, say on the value of another field, e.g.:
    Code:
    update TABLE set Host='1.2.3.4' where date='2012-10-29';

Posting Permissions

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