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>`_.