[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]