On Mon, Apr 14, 2008 at 10:29 AM, Jason Pruim <[EMAIL PROTECTED]> 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]
It is probably trying to insert a string of no length into the not null field. Try it with: SET SQL_MODE = ''; -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]