I am new to MySql and I am having troubles getting the primary keys to do what I want. Here is the situation.
I am building a database where there are 2 types of users that can access and change information. Because each type of user will be accessing a different part of the database, I wanted to set it where Type 1 users got a primary key "UserID" that was even, while Type 2 users got a "UserID" that was odd. I have set the auto-increment value in both registration forms to 2 but when I set the default in the type 1's to 2 and the type2's to 1, it does not work and they are both getting the same numbers for their user id. Is there something I am missing or is there a different field that I need to set to make this work right or is this something that can't be done in MySql? Any help would be appreciated. P.S. I am more familiar with MSSqlServer than I am with MySql, if that helps. I know how to do this in MSSqlServer but I am lost here. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
