首先创建一个表abc结构如下
CREATE TABLE `cc`.`loup` (
`id` INT( 4 ) NOT NULL AUTO_INCREMENT ,
`datetimes` INT( 4 ) NULL ,
`ipaddress` VARCHAR( 20 ) NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM
再批量插入数据
INSERT INTO `loup` (`id`, `datetimes`, `ipaddress`)
VALUES
(1, 1271865600, '127.0.0.1'),
(2, 1271865600, '127.0.0.1'),
(3, 1271865600, '127.0.0.1'),
(4, 1271865600, '127.0.0.1'),
(5, 1271865600, '127.0.0.1'),
(6, 1271865600, '127.0.0.1'),
(7, 1271952000, '192.168.0.1'),
(8, 1271952000, '192.168.0.1'),
&nb