DROP TABLE IF EXISTS `userlog`;
CREATE TABLE `userlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cameraChannel` int(11) NOT NULL,
`cameraIp` varchar(255) NOT NULL,
`cameraName` varchar(45) NOT NULL,
`date` datetime NOT NULL,
`userIp` varchar(255) NOT NULL,
`userName` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UK_13sdl4cpv5sr2ml62a0af4oys` (`cameraName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
上面是建的userlog的表。
actStr.Format("INSERT INTO userlog VALUES (14,2,'192.192.192.192','201队部','2015-09-14 16:00:01','192.168.0.110','admin','test')");
这是插入到数据库的代码 有哪里有问题吗?