Increment value in mysql update query

Question

I have made this code for giving out  1 point  but it doesn t work properly   mysql query       UPDATE member profile      SET points       points       1      WHERE user id       userid          the  points variable is the user  s points right now   I want it to plus one to it   so example if he had like 5 points  it should be 5 1   6   but it doesnt  it just changes to 1  What have i done wrong  thank you

User · Answer

Why don t you let PHP do the job    UPDATE member profile SET points         points 1        WHERE user id       userid

User · Answer

Remove the   around the point   mysql query  UPDATE member profile SET points    points   1 WHERE user id       userid         You are  casting  an integer value to string in your original query

User · Answer

Also  to  increment  string  when update  use CONCAT  update dbo test set foo CONCAT foo   bar   where 1 1

User · Answer

You can do this without having to query the actual amount of points  so it will save you some time and resources during the script execution     mysql query  UPDATE  member profile  SET  points    points    1 WHERE  user id       intval  userid          Else  what you were doing wrong is that you passed the old amount of points as a string  points  5  1   and you can t add a number to a string

User · Answer

You could also just do this   mysql query       UPDATE member profile      SET points   points   1     WHERE user id       userid

User · Answer

You should use PDO to prevent SQL injection risk   You can connect to DB like this    try        pdo options PDO  ATTR ERRMODE    PDO  ERRMODE EXCEPTION       bdd   new PDO  mysql host xxxx dbname xxxx    user    password    pdo options        bdd- gt query  SET NAMES  utf8       catch  PDOException  e        exit  Error        No need to query DB to get the number of points  You can increment directly in the update query  points   points   1     note   Also  it   s not a good idea to increment the value with PHP because you need to select first the data and the value can changed if other users are updated it     req    bdd- gt prepare  UPDATE member profile SET              points   points   1             WHERE user id    user id      req- gt execute array       user id    gt   userid

User · Answer

UPDATE member profile SET points   points   1 WHERE user id       userid

User · Answer

Who needs to update string and numbers SET  a   0  UPDATE obj disposition SET CODE   CONCAT  CD     a   a 1

User · Answer

Hope I m not going offtopic on my first post  but I d like to expand a little on the casting of integer to string as some respondents appear to have it wrong    Because the expression in this query uses an arithmetic operator  the plus symbol     MySQL will convert any strings in the expression to numbers   To demonstrate  the following will produce the result 6   SELECT   05 05     95     String concatenation in MySQL requires the CONCAT   function so there is no ambiguity here and MySQL converts the strings to floats and adds them together    I actually think the reason the initial query wasn t working is most likely because the  points variable was not in fact set to the user s current points  It was either set to zero  or was unset  MySQL will cast an empty string to zero  For illustration  the following will return 0   SELECT ABS        Like I said  I hope I m not being too off-topic  I agree that Daan and Tomas have the best solutions for this particular problem

[php] Increment value in mysql update query

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to sql-update