updating columns with a sequence number mysql

by 
SET @rank:=0;
update T
set Number=@rank:=@rank+1;

UPDATE

alternative way with one statement

UPDATE T
JOIN (SELECT @rank := 0) r
SET Number=@rank:=@rank+1;

More Related Contents:

  1. How to find similar results and sort by similarity?
  2. ORDER BY alphabet first then follow by number
  3. If two columns are 1 then make new column
  4. How can I return pivot table output in MySQL?
  5. MySQL – Get row number on select
  6. Natural Sort in MySQL
  7. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  8. Retrieving the last record in each group – MySQL
  9. Cast from VARCHAR to INT – MySQL
  10. Required to join 2 tables with their FKs in a 3rd table
  11. Does COUNT(*) always return a result?
  12. Operand Should Contain 1 Column – MySQL NOT IN
  13. Connect By Prior Equivalent for MySQL
  14. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  15. How to convert all tables from MyISAM into InnoDB?
  16. SQL Query to show nearest date?
  17. How to create relationships in MySQL
  18. Mysql Improve Search Performance with wildcards (%%)
  19. Best practices for SQL varchar column length [closed]
  20. ALTER TABLE to add a composite primary key
  21. How to get the count of each distinct value in a column? [duplicate]
  22. What are differences between INSERT and UPDATE in MySQL?
  23. Set value to NULL in MySQL
  24. SELECT query return 1 row from each group
  25. MySql Single Table, Select last 7 days and include empty rows
  26. mysql SQL: specific item to be first and then to sort the rest of the items
  27. When is a timestamp (auto) updated?
  28. MySQL Group By Hours
  29. RMySQL dbWriteTable with field.types
  30. mySQL query to search all tables within a database for a string?

Leave a Comment