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]
