MySQL一次插入多行数据

 

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())

 

posted @ 2015-12-08 14:17  morein2008  阅读(1967)  评论(0)  编辑  收藏  举报