importing data from textfile

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

i have been using phpmyadmin, and was trying to import a text file,
which is at into a database, which has
4 fields, each varchar with a length of 100, comma delimited, however
it seems to input into a strange order, results are at

i chose comma for the field terminator, and left fields enclosed by
blank, and left the newline as the default as i was on a windows

any help whatsoever would eb great,
many thanks,

Re: importing data from textfile

Do a search for mysqlimport or LOAD DATA LOCAL INFILE

Site Timeline