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,
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:
|
On Mon, Apr 14, 2008 at 10:47 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
It is probably trying to insert a string of no length into the not null
field.
Try it with:
SET SQL_MODE = '';
Above should read into an int field, while the server is in strict mode.
--
Rob Wultsch
[EMAIL PROTECTED]
On Apr 14, 2008, at 2:01 PM, Rob Wultsch wrote:
On Mon, Apr 14, 2008 at 10:47 AM, Rob Wultsch [EMAIL PROTECTED]
wrote:
It is probably trying to insert a string of no length into the not
null field.
Try it with:
SET SQL_MODE = '';
Above should read into an int field, while the server is in
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
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:
|
On Mon, Apr 14, 2008 at 3:33 PM, Jason Pruim [EMAIL PROTECTED] wrote:
On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
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
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
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown [EMAIL PROTECTED] wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and then post back here for the MySQL archives.
On Apr 14, 2008, at 4:37 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown [EMAIL PROTECTED]
wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and
10 matches
Mail list logo