Answers for "how to increment column value in mysql"

mysql increment value by 1 in update

mysql_query("
    UPDATE member_profile 
    SET points = points + 1
    WHERE user_id = '".$userid."'
");

Posted by: Guest on May-03-2021

auto increment column in mysql query results

SET @auto_increment=0;
SELECT @auto_increment := @auto_increment+1 AS `No`;

Posted by: Guest on March-28-2021

Code answers related to "how to increment column value in mysql"