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
