Did you try it?
What happened?
John Nielsen wrote:
>
> Hey everyone,
>
> This may have already come up a couple of times in the mailling list, but I
> I was wondering with mysql-3.22.32 if you can have two auto_increment's
> in one table, e.g.:
>
> +----------+--------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +----------+--------------+------+-----+---------+----------------+
> | username | char(32) | YES | | NULL | |
> | passwd | char(32) | YES | | NULL | |
> | uid | mediumint(9) | | PRI | 0 | auto_increment |
> | gid | mediumint(9) | YES | | NULL | |
> | gecos | char(32) | YES | | NULL | |
> | home_dir | char(32) | YES | | NULL | |
> | shell | char(32) | YES | | NULL | |
> | maildrop | char(128) | YES | | NULL | |
> | id | tinyint(4) | | PRI | 0 | auto_increment |
> +----------+--------------+------+-----+---------+----------------+
>
> Now i know this table will not work with the two PRI keys,
> but i was wondering *if* i could change one to just another key, as well
> as keep it's auto_increment's on both if possible.
>
> Thanks in Advanced.
>
> John.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
