MySQL Procedure To Get Incremental Numbers

9th March 2009

Run the following table definition to create a table called tests in the test database.

  1. <p>Fill it with some default values:
  2.  
  3. <pre language=">
  4.  
  5. Now lets say that you want to find the values in the table, but that you want to increment a value for each row, the following procedure will do this. If you are using the MySQL Query browser then open a script table and past the following and execute, changing any database/table definitions.
  6.  
  7.  
  8.  
  9. The value that you pass to the procedure is used to work out the increment. So in this case the output would be something like the following:
  10.  
  11. id RunningSum
  12. 1 4
  13. 2 8
  14. 3 12
  15. 4 16

Add new comment

The content of this field is kept private and will not be shown publicly.