Hi Scoot,

I do my table structure like that

CREATE TABLE `test_table` (
  `timestamp` date NOT NULL default '0000-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` ( `timestamp` , `data` )
VALUES (
CURDATE( ) , 'test1'
);

and this is the result

SQL-query: SELECT * FROM `test_table` LIMIT 0, 30;
Rows: 1
timestamp data
2004-10-18test1

Cheers,
Ferhat

----- Original Message ----- 
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 3:20 PM
Subject: Date as Primary ID


> How do I create table that uses timestamp in yyyy-dd-mm format as primary
id
> (no duplicates)?
>
> -- 
> 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]

Reply via email to