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:
  3. <pre language=">
  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.
  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:
  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.