Re: LOAD DATA INFILE ERROR 1172 (42000)

[eric tse]

Thank you

mysql> LOAD DATA INFILE '/dsk01/apache/tools/IPManagement/dev/scripts/outputs/axial.dmz.reg.sort.entry' replace INTO TABLE ServerIPs FIELDS TERMINATED BY '|' (regip, server);
ERROR 1172 (42000): Result consisted of more than one row


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ServerIPs | CREATE TABLE `ServerIPs` (
`regip` varchar(15) NOT NULL,
`server` varchar(20) DEFAULT NULL,
`lbip` varchar(15) DEFAULT NULL,
`used` varchar(1) DEFAULT NULL,
`balance` varchar(25) DEFAULT NULL,
`keepalive` varchar(30) DEFAULT NULL,
PRIMARY KEY (`regip`),
KEY `serverip` (`regip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-----------+-----------------------------

[b2064@fore ~] cat /dsk01/apache/tools/IPManagement/dev/scripts/outputs/axial.dmz.reg.sort.entry
142.34.230.9|axial.dmz
142.34.230.12|axial.dmz
[b2064@fore ~]