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
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
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
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` (
- 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 wasn't
possible?
I'm trying to figure out a way
:[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]
Sent: Monday, October 18, 2004 10:11 AM
Subject: RE: Date as Primary
: 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
My objective is to set up the projected estimate for day by day basis in
ahead of time, then fill in the actual value when time