I think it is not possible to have things as you stated, but you could have an auto_increment field and a date field in your table. Every time you insert a record, you set the date field and the other field will auto_increment himself.
Then, when you want to do a select, you may do as: SELECT CONCAT(id_field,'-',date_field) AS ID, .... ..... -- Diana Soares -----Original Message----- From: Ron McKeever [mailto:[EMAIL PROTECTED] Sent: Tue 11/25/2003 1:43 PM To: Chris Cc: mysql Subject: RE: create own auto increment number 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]