Answer the question
In order to leave comments, you need to log in
How to create unique values for multiple records for DUPLICATE KEY UPDATE?
CREATE TABLE `mt_viewed` (
`id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`PHPSESSID` varchar(32) NOT NULL,
`putdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `product_id` (`product_id`,`PHPSESSID`,`putdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question