Ferhat BINGOL wrote:
Hi Scoot,
I do my table structure like that
CREATE TABLE `test_table` (
`timestamp` date NOT NULL default '-00-00',
`data` varchar(5) NOT NULL default '',
PRIMARY KEY (`timestamp`),
KEY `timestamp` (`timestamp`)
) TYPE=MyISAM;
Correct me if I'm wrong, but I think t
.
Rhino
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Rhino'" <[EMAIL PROTECTED]>; "'Mysql ' (E-mail)"
<[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 11:19 AM
Subject: RE: Date as Primary ID
&g
ailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 11:14 AM
To: Scott Hamm; 'Mysql ' (E-mail)
Subject: Re: Date as Primary ID
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sen
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 10:11 AM
Subject: RE: Date as Primary ID
> Ok, so that means what Jay Blanchard just now said recently
Hi Scoot,
I do my table structure like that
CREATE TABLE `test_table` (
`timestamp` date NOT NULL default '-00-00',
`data` varchar(5) NOT NULL default '',
PRIMARY KEY (`timestamp`),
KEY `timestamp` (`timestamp`)
) TYPE=MyISAM;
Than I send a query as below
INSERT INTO `test_table` (
mething 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
Scott Hamm wrote:
How do I create table that uses timestamp in -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
