Re: I want to AUTO_INCREMENT fields
| From: | David Robley | Date: | Thu, 26 Jul 2001 08:49:57 +0000 |
| Subject: | Re: I want to AUTO_INCREMENT fields | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-59707@lists.php.net to get a copy of this message | ||
On Thu, 26 Jul 2001 18:53, elias wrote:
> Hi!
>
> I want to have to fields,
> first field is the primary key and is called 'id' and is an integer,
> and i want another field of type integer to be also autoincremented...
If you are using mysql, this snippet from the manual answers your
question:
NOTE: There can be only one AUTO_INCREMENT column per table, and it must
be indexed.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Don't play stupid with me! I'm better at it.