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]