How to renumber primary index

by

I agree other methods will work but I’m just giving a different idea. This will do without any temp table creation requirements::

SET @i=0;
UPDATE table_name SET column_name=(@i:=@i+1);

More Related Contents:

  1. MySQL: Alternatives to ORDER BY RAND()
  2. MySQL LIKE IN()?
  3. Auto Increment after delete in MySQL
  4. Unioning two tables with different number of columns
  5. NULL in MySQL (Performance & Storage)
  6. In MySQL queries, why use join instead of where?
  7. MySQL function to find the number of working days between two dates
  8. MySQL Trigger to prevent INSERT under certain conditions
  9. Importance of varchar length in MySQL table
  10. Stored Procedure with optional “WHERE” parameters
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. MySQL “between” clause not inclusive?
  14. SQLite – ORDER BY RAND()
  15. How to search multiple columns in MySQL?
  16. MySQL – Selecting data from multiple tables all with same structure but different data
  17. Can a stored procedure/function return a table?
  18. SQL SELECT to get the first N positive integers
  19. Sorting string column containing numbers in SQL?
  20. Multiple Ranks in one table
  21. Create date from day, month, year fields in MySQL
  22. The difference between ‘AND’ and ‘&&’ in SQL
  23. Can I use a MySQL database with an App Engine application
  24. How can I make an average of dates in MySQL?
  25. What is the best way to generate ranks in MYSQL?
  26. What does collation mean?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment