RE: auto increment problems

2001-10-04 Thread Paul DuBois
ew table first. > >Thanks > > >-Original Message- >From: Will French [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 04, 2001 1:50 PM >To: MySQL >Subject: RE: auto increment problems > > >> Error: 1062 - Duplicate entry '2147483647' for key 1 >T

RE: auto increment problems

2001-10-04 Thread Schmidt, Allen J.
-Original Message- From: Will French [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 1:50 PM To: MySQL Subject: RE: auto increment problems > Error: 1062 - Duplicate entry '2147483647' for key 1 That number is the largest number which can be stored in a signe

RE: auto increment problems

2001-10-04 Thread Will French
rom: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 1:34 PM > To: MySQL > Subject: auto increment problems > > > I am sure this has been discussed but have not found specifically what I > need. > > I have a MyISAM table with an auto_increme

RE: auto increment problems

2001-10-04 Thread Will French
rom: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 1:34 PM > To: MySQL > Subject: auto increment problems > > > I am sure this has been discussed but have not found specifically what I > need. > > I have a MyISAM table with an auto_increme

auto increment problems

2001-10-04 Thread Schmidt, Allen J.
I am sure this has been discussed but have not found specifically what I need. I have a MyISAM table with an auto_increment primary key field. It sorta went nuts and started inserting strange new values. I decided to follow the stated procedures for resetting an auto_increment field by deleting a

RE: duplicate records, auto-increment problems, question

2001-03-28 Thread Cal Evans
H, Cal http://www.calevans.com -Original Message- From: Eve Edelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 6:15 PM To: [EMAIL PROTECTED] Subject: duplicate records, auto-increment problems, question I am starting out to learn database scripting using PHP/mySQL/Apache on Win98:

duplicate records, auto-increment problems, question

2001-03-27 Thread Eve Edelson
I am starting out to learn database scripting using PHP/mySQL/Apache on Win98: Apache 1.3.14(Win32) with PHP 4.04pl1 MySQL 3.23.28-gamma, localhost via TCP/IP As an exercise I wrote a php script which dumps the contents of a form into a database, prints the contents of the table (most rec