Thread Status:

Not open for further replies.

1. Offline

   Tythus

   Code:

   INSERT INTO user (user, tokens) VALUES ('tythus', '4');

   So if the user 'tythus' already exists how do I make it update instead?
   
   sir bumps a lot
   
   >_>
   
   EDIT by Moderator: merged posts, please use the edit button instead of double posting.

    

   Last edited by a moderator: Jun 7, 2016

   Tythus, Feb 28, 2014

   #1
2. Offline

   Maulss

   "UPDATE `<table>` SET <column> = <value> WHERE <row> = <value>"
   
   EDIT: More specifically, in your case, you would do this:
   "UPDATE user SET tokens = 4 WHERE user = tythus"

    

   Maulss, Mar 1, 2014

   #2

Thread Status:

Not open for further replies.

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in