using MyAdmin to build the MySql-Having trouble setting auto-increment for primary key
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]
Re: using MyAdmin to build the MySql-Having trouble setting auto-increment for primary key
Dana Terrell wrote: 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. Add another column for user type. Encoding special meaning to certain values of an otherwise unrelated column is a bad idea. 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. Auto increment fields increment by one, not the default value. 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
