MySQL Server Forum - importing data from textfile

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

importing data from textfile

metrix007@yahoo.com

2005-08-12, 3:23 am

hello,

i have been using phpmyadmin, and was trying to import a text file,
which is at www.secmaritsolutions.com/d.txt 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
www.secmaritsolutions.com/pro.php

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
machine.

any help whatsoever would eb great,
many thanks,
josh

KolbSoft Technologies

2005-08-19, 3:23 am

Do a search for mysqlimport or LOAD DATA LOCAL INFILE

Sponsored Links