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]