CREATE TABLE `viewhistory` ( `viewid` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `video` varchar(255) NOT NULL, `viewtime` datetime NOT NULL, PRIMARY KEY (`viewid`) ) INSERT INTO viewhistory VALUES (9,3,'this',NOW()), (10,3,'is',NOW()), (11,3,'a',NOW()), (12,3,'movie',NOW())