Hi All,
I want to load data from dump file to MySQL table using LOAD DATA INFILE
but there is Error 1366 :
mysql> LOAD DATA
-> INFILE 'D:/SITE/SOMETABLE.SQL'
-> INTO TABLE SOMETABLE
-> FIELDS TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY ''
-> LINES TERMINATED BY ')';
ERROR 1366 (HY000): Incorrect integer value: '--MySQL dump 10.10
--
--S' for column 'ID' at row 1
this is the header of my dump file:
DROP TABLE IF EXISTS `sometable`;
CREATE TABLE `sometableo` (
`ID` smallint(6) NOT NULL auto_increment,
`Name` varchar(30) NOT NULL,
`title` tinytext,
`description` tinytext,
`cat` tinytext,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `sometable` WRITE;
/*!40000 ALTER TABLE `sometable` DISABLE KEYS */;
INSERT INTO `sometable` VALUES (79,'110_1099','AAA','AAAAAA','AAA'),(80,'110_1100','AAA','DFGDFGF','AAA'),
any idea for solving the problem?
---------------------------------
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.
