Ok, so that means what Jay Blanchard just now said recently wasn't possible?
I'm trying to figure out a way to ensure that date is not duplicated i.e.:
create performance (
`DateID` whatever,
`Projected_Num` int(7),
`Actual_Num` int(7),
primary key [something to prevent DateID duplication]
);
-----Original Message-----
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 9:42 AM
To: Scott Hamm
Cc: 'Mysql ' (E-mail)
Subject: Re: Date as Primary ID
Scott Hamm wrote:
>How do I create table that uses timestamp in yyyy-dd-mm format as primary
id
>(no duplicates)?
>
>
>
You can't.
Timstamps are only unique down to 1 second.
It is quite possible to insert hundreds, if not thousands of records in
that length of time.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
