auto_increment not working

From: Date: Sat, 26 Aug 2000 19:24:46 +0000
Subject: auto_increment not working
Groups: php.db 
Request: Send a blank email to php-db+get-2395@lists.php.net to get a copy of this message
I have a MySQL database with the following structure. The id_number field is a primary key and is set to auto_increment. But, auto_increment has stopped working, and now I have multiple customer records with a null id_number value. Anyone know why this would happen? TABLE STRUCTURE: +------------+----------------------+------+-----+---------+---------------- + | Field | Type | Null | Key | Default | Extra | +------------+----------------------+------+-----+---------+---------------- + | id_number | int(11) | | PRI | 0 | auto_increment | | enter_date | date | YES | | NULL | | | fname | varchar(35) | YES | | NULL | | | lname | varchar(35) | YES | | NULL | | | email | varchar(100) | YES | | NULL | | | address | varchar(70) | YES | | NULL | | | city | varchar(35) | YES | | NULL | | | state | char(2) | YES | | NULL | | | zip | varchar(9) | YES | | NULL | | | country | varchar(50) | YES | | NULL | | | phone | varchar(20) | YES | | NULL | | | browser | varchar(70) | YES | | NULL | | | comments | blob | YES | | NULL | | | registered | enum('true','false') | YES | | NULL | | +------------+----------------------+------+-----+---------+---------------- + -- Randy Perry rgp systems Mac Consulting/Sales

« previous php.db (#2395) next »