Problem with an auto_increment field

I have a table with a field (ID) with this properties:
- auto_increment
- int(11)
- KEY PRIMARY
- Default NULL

The problem is that when I add a new register, in this field always put automatical the number 2147483647 (the max. number of integer).

The table only has 35 registers.

After I can change the field ID.

What Can I do?

I am not perfectly sure, but I think that it should not be

Default NULL

you should have something like

CREATE TABLE person (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(60) NOT NULL,
PRIMARY KEY (id)
);

Thanks, but this is not the solution.

Post here a part of the code where you insert a new record into that table.

The code is not relevant in this case, because I add the new register with SQLyoy, My-Sql Front, phpMyAdmin, etc, and always is the same problem.

I think that the problem is in the table.

In the field I have not any negative number.