Ed, If the code below is exactly what you are using, please check 6.4.9 LOAD DATA INFILE Syntax for the default separator, terminator, etc rules.
Regards, =dn ----- Original Message ----- From: "William R. Mussatto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: 31 January 2002 01:01 Subject: Re: Batch load of data problems (fwd) > I'm forwarding this to the list since I can't offer any more advice > myself. ---------- Forwarded message ---------- > Date: Wed, 30 Jan 2002 19:41:32 -0500 > From: [EMAIL PROTECTED] > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Subject: Re: Batch load of data problems > > I guess I didn't make myself very clear. Here's what I run: > > mysql < create.sql > > This is create.sql: > > use test; > create table if not exists persons (pid mediumint unsigned not null auto_increment >primary key, name > varchar(50)); > load data infile "test.dat" replace into table persons; > > This is test.dat, located both under the data directory and the test database >directory (tab-delimited): > > 1 Joseph > 2 Bill > > The table looks like this after: > > select * from persons; > > Pid Name > 1 NULL > 2 NULL > > I don't have Joseph and Bill in the table persons. This is the problem. > Have any ideas? > > Thanks, > > Eurico > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
