help with load data infile

2001-11-30 Thread Ward, Mark 

Hello, 

I've got a bunch of tables from MS Excel that I've exported to tab delimited
files that I'm trying to load into mySQL. I'm having problems getting the
data in properly though. 

For instance, I have set up the ids so that they are incremented
automatically. I have the initial records in my text file with ids already.
Should I take out the ones that I have assigned and let mySQL assign new
ids? 

Also, in another table, I have primary keys that are not incremented
automatically. Yet when I try to insert the data, I get errors saying that
there are duplicate values in my file. That cannot be since I the data in my
file is unique.

It would be greatly appreciated if anyone can help with this.

Mark Ward


-
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

Help with LOAD DATA INFILE

2001-04-18 Thread David Morris 

If this is the incorrect place to ask, please feel free to point me in the
right direction!

I've got an old mySQL database that imports a load of data with LOAD DATA
INFILE from a number of CSV files.

One particular import is only processing about 50% of the 13,000-odd
records. The LOAD command shows a large number of warnings on completion.
Although I've got through the manuals, I can't see any pointers that would
help me find out what these warnings relate to. I think if I can identify
what the warnings are, I'll probably find out why I can't get the other 50%
of the records.


Clues, abuse and assistance gratefully received!

TIA,

--
David Morris
IT Manager, ALLVAC Ltd, Sheffield, UK
work: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]   http://www.davidm.demon.co.uk


-
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