[thelist] LOAD DATA MYSQL

Adrian Fischer info at aussiebidder.com
Sun Sep 24 15:46:38 CDT 2000


Thanks Matt,

I do have access, which is what I dont understand. I ended doing the hard
way with a gazillion inserts.  I wrote them into a text file and called the
file in phpadmin so it wasnt that bad, just a lot of cut and pasting.

I think it may have been the way I had the data written in the text file
initialy. I had written down the page but I didnt have \n or any other end
of line indication. Not sure that would have made a difference.
I thought it may also have been the syntax for the load that I was using.
Can you confirm that this is correct?
LOAD DATA INFILE 'categories.sql' INTO TABLE all_cats;
'categories.sql' was just the name I gave to the data file to be loaded and
'all_cats' was the name of the table.  There is name name for the field to
be loaded...should there be?  The example I followed didnt show one?

If I can nail this sucker for next time it could save me a heap of time.

Adrian Fischer






More information about the thelist mailing list