On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 1:29 PM, 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';
[snip!]
The error that I'm getting is:
| Level | Code | Message
|
+---------+------
+----------------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: 'Record' for column
'Record' at
row 1
That's because it's attempting to insert the name of the columns
from your CSV into MySQL --- and 'Record' is not a valid INT.
Replaced field name with "0" and had the same end result... Just no
error. But I get the first row included! Which is just field names and
a "0" for good measure :)
Any other ideas Master Brown? :)
***Before I get yelled at for not showing respect please note that I
know Dan from another list and I am allowed to give him crap like this
no matter what he says :P
--
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]
