Chris, Thats not what i think im Asking.
I was wondering if its possible to have a AUTO_INCREMENT ID number also have the format mmddyy. So when you query the table it would be the PRIMARY KEY AUTO_INCREMENT ID field: select * from table: name email phone ID Bugs [EMAIL PROTECTED] 5554321 1-112403 Bunny [EMAIL PROTECTED] 5554331 2-112403 name [EMAIL PROTECTED] 5554341 3-112403 bbbb [EMAIL PROTECTED] 5554351 4-112503 Thanks, Ron -----Original Message----- From: Chris [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 5:30 PM To: MySQL List Subject: RE: create own auto increment number Are you talking about a multiple key PRIMARY KEY? CREATE TABLE Blah ( MyDate datetime, MyID INT NOT NULL AUTO_INCREMENT, ... PRIMARY KEY (MyDate,MyID) ) for each unique MyDate the Auto Increment sequence will start over. If that's not what you're asking for, could you clairfy some more? Chris -----Original Message----- From: rmck [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: create own auto increment number I have a request to create an auto increment field that increments like so: 1-112403 2-112403 3-112403 4-112503 etc... Is that possible??? Any variant of that is fine the big issue is they want the Date with the ID number of the record. Thanks, Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]