Re: auto-increment not working?? MySQL
| From: | barophobia | Date: | Mon, 12 Jul 2004 21:27:48 +0000 |
| Subject: | Re: auto-increment not working?? MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-190298@lists.php.net to get a copy of this message | ||
On Mon, 12 Jul 2004 15:36:20 -0500, Jay Blanchard
<jay.blanchard@niicommunications.com> wrote:
> The guys on the MySQL list do. Have you read this-->
> http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html
not for this issue no.
the problem for those that read this later is not that i am using
multiple primary keys but rather the order in which they are defined.
'id' should be first in the list. once i moved 'id' to the first spot
the table began incrementing as per expected behavior.
thanks jay.
chris.