Re: Load data infile or import

[Scott Haneda]

on 03/31/2004 01:02 AM, Harald Fuchs at [EMAIL PROTECTED] wrote:

 Where the new data to import is missing the Mname and id, so I will create
 full complete insert statements, but how to load that in?
 
 Depending on your table structure, the following quotation from The
 F*** Manual might apply:


If it is too much trouble to answer, then don't.  So I missed the part on
that in the manual, kill me!  This is supposed to be a help mailing list,
not a rub it in their face cause they overlooked something.

I would bet 90% of all questions are in the manual, this would be a really
quiet list if everyone looked in the manual.  Mellow out.
-- 
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com   Fax: 313.557.5052
[EMAIL PROTECTED]Novato, CA U.S.A.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Load data infile or import

[Scott Haneda]

I have a few hundred thousand records to import to a database, there are
already a few hundred thousand records in the database now.

What is the best way to append these new records to the old database?

I can not seem to use load data infile unless I want to preformat the data
to have the exact same amount of fields as the old database.  Basically, I
have something like

Id
Fname
Mname
Lname

Where the new data to import is missing the Mname and id, so I will create
full complete insert statements, but how to load that in?

-- 
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com   Fax: 313.557.5052
[EMAIL PROTECTED]Novato, CA U.S.A.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]