another auto increment

[MDanz]

i already have the id field which is auto increment primary key. I have another field that i want to be auto increment/autonumber but phpadmin/mysql doesn't allow? how else do i have a field with an autonumber?

[is_set]

why to do that
i'm sure there is another solution

[MDanz]

i just need a field that adds 1 to the current integer.... auto increment does that perfectly, but it only allows 1?

[liamfriel]

The other solution would be to calculate the value using the auto incremented value i.e if your value started at 5 and the id was 7 instead of starting a count wasting db space just get the id and 5.

$new_num = $row + 5;

[mschroeder]

You can not have more than one auto-increment column in the same table in MySQL.

You could however do something like:

/*
  Table
  +-----------+------------+
  | RowId (AI)| RowCount   |
  +-----------+------------+
  | 1         | 37         |
  +-----------+------------+
  | 2         | 51         |
  +-----------+------------+
  | 3         | 26         |
  +-----------+------------+
*/

UPDATE Table SET RowCount = RowCount + 1 WHERE RowId = 1

That query would increment your rowcount by 1 each run.