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]