Re: Fwd: Re: Bug in auto_increment

2002-12-16 Thread Steve Yates
On Sun, 15 Dec 2002 17:38:49 -0600, Paul DuBois wrote: >>>INSERT INTO gebaeude_daten VALUES (0, 'Bank Stufe 1', 1000, 30, 900, 1); What happens if you use a value of NULL instead of 0? Inserting a field with 0 tells the table to generate a value on its own, like it's supposed to.

Re: Fwd: Re: Bug in auto_increment

2002-12-16 Thread Michael T. Babcock
Paul DuBois wrote: manner. AUTO_INCREMENT columns are for use only with *positive* integers, and any attempt to use them otherwise will eventually cause you grief. Just to point out, a lot of people get confused about the definition of positive integers, especially in how it relates to zero.

Re: Fwd: Re: Bug in auto_increment

2002-12-15 Thread Paul DuBois
At 22:42 +0100 12/15/02, Dennis Schwerdel wrote: I think you did not properly process this request. The phenomenon you describe below is not a bug in MySQL. The problem is that you are trying to use an AUTO_INCREMENT column in an unsupported manner. AUTO_INCREMENT columns are for use only with