Insert a row no in new column in MySQL

Add a row no. in new column Update a column with record row no in MySQL Execute the below query in Mysql to update an row no. in the specified column   My Sql Query Example¬† SET @pos := 0 UPDATE userinfo SET fuserid = ( SELECT @pos := @pos + 1 ) ORDER BY updated_at DESC @pos -> Variable Name userinfo -> Table Name fuserid -> Column Name

Read More