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 t
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 archive
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: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 wit
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
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 Ever
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
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 PROT
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:
>
> |
