1renumber 2======== 3 4Some times you lost continuity on tables with auto increment fields, for 5example instead of having a sequence like : 1 2 3 4 yo have something like: 1 5 618 30; in this cases, the method ``renumber('table')`` renumbers the table. 7 8 9Parameters 10.......... 11 12:: 13 14 renumber($table, $col='id') 15 16 17:$table: name of the table to renumber. 18:$col: name of the column with the **auto-increment** attribute. 19 20 21Example 22....... 23 24 25.. code-block:: php 26 :linenos: 27 :emphasize-lines: 12 28 29 <?php 30 31 require_once 'dalmp.php'; 32 33 $user = getenv('MYSQL_USER') ?: 'root'; 34 $password = getenv('MYSQL_PASS') ?: ''; 35 36 $DSN = "utf8://$user:$password".'@127.0.0.1/test'; 37 38 $db = new DALMP\Database($DSN); 39 40 $db->renumber('table'); 41 42Example where uid is the auto-increment column: 43 44.. code-block:: php 45 :linenos: 46 :emphasize-lines: 12 47 48 <?php 49 50 require_once 'dalmp.php'; 51 52 $user = getenv('MYSQL_USER') ?: 'root'; 53 $password = getenv('MYSQL_PASS') ?: ''; 54 55 $DSN = "utf8://$user:$password".'@127.0.0.1/test'; 56 57 $db = new DALMP\Database($DSN); 58 59 $db->renumber('table', 'uid'); 60 61 62.. seealso:: 63 64 MySQL `AUTO_INCREMENT <http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html>`_.