RE: **[SPAM]** Date as Primary ID

[Jay Blanchard]

[snip]
How do I create table that uses timestamp in yyyy-dd-mm format as
primary id
(no duplicates)?
[/snip]

CREATE TABLE `tblFoo` (
  `timeID` timestamp(14) NOT NULL,
  PRIMARY KEY  (`timeID`),
) TYPE=MyISAM;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]