Hi again everyone,
After taking the advice of someone offlist I tried the "IGNORE 1
LINES" and that didn't help... Same result. I've tried a tab delimited
file, and a comma separated file. Same result with both. Any other
ideas? :)
On Apr 14, 2008, at 1:29 PM, Jason Pruim wrote:
Hi Everyone,
I am attempting to use this command: load data infile '/volumes/
raider/elks.test.txt' into table elksCurrent fields terminated by
'\t' lines terminated by '\n';
My table is created as such:
| elksCurrent | CREATE TABLE `elksCurrent` (
`FName` varchar(40) default NULL,
`LName` varchar(40) default NULL,
`Add1` varchar(50) default NULL,
`Add2` varchar(50) default NULL,
`City` varchar(50) default NULL,
`State` varchar(20) default NULL,
`Zip` varchar(14) default NULL,
`XCode` varchar(50) default NULL,
`Reason` varchar(20) default NULL,
`Record` mediumint(11) NOT NULL auto_increment,
PRIMARY KEY (`Record`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 |
The error that I'm getting is:
| Level | Code |
Message |
+---------+------
+----------------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: 'Record' for column
'Record' at row 1
The row it's choking on is this:
FIRST NAME LAST NAME ALT ADD ADD CITY ST ZIP XCODE
Reason Record
First Name Last Name 123 Main St Holland MI 49424
1 \t \t \n
(Yes I did change the name to protect the innocent! But all data is
the correct type in each row)
Any Ideas?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
