In your case something like this will do: LOAD DATA INFILE "data.txt" INTO TABLE my_table FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\r\n' # or '\n' - depending on your system IGNORE 1 LINES # if applicable ( First, Last, Title ) # actual order of your columns in your txt file, mapping columns names
HTH Ignatius _________________________ ----- Original Message ----- From: "JeRRy" <[EMAIL PROTECTED]> To: "Ignatius Reilly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 01, 2004 10:44 Subject: Re: [PHP-DB] plain-text file (.txt) to mysql database > Hi, > > So would I need to edit anything in my .txt file? > > Could you show me an example on what you mean by: > > you can specify which > columns of your text file > goes to what DB column. > > > > Because my text file has first , last , title > seperated by a space and a new entry is seperated by a > enter. (new line) > > I took a look at www.mysql.com and had a read on 'LOAD > DATA' but am not 100% sure on how it works with my > sort of .txt file setup. > > If you could show me an example that worked with my > .txt file that would be great, or would I need to edit > my .txt file somewhat? > > Sorry about this, never used a .txt file for use of > mysql before but since I need to do alot of entries at > once it would be the easiest way to do it. > > Thanks! > > > > > --- Ignatius Reilly <[EMAIL PROTECTED]> wrote: > > G'day, mate, > > > > With MySQL LOAD statement, you can specify which > > columns of your text file > > goes to what DB column. > > > > HTH > > Ignatius > > _________________________ > > ----- Original Message ----- > > From: "JeRRy" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, March 01, 2004 10:08 > > Subject: [PHP-DB] plain-text file (.txt) to mysql > > database > > > > > > > Hi, > > > > > > Quick question, does anyone know of a program/site > > > that could do the following: > > > > > > I have a .txt file written in notepad. > > > > > > Bob Someone Mr > > > > > > Now I have a db with the fields: > > > > > > First Last Title > > > > > > Now the .txt file looks something like this: > > > > > > Bob Someone Mr > > > Susan Taylor Miss > > > Andrea Nothing Ms > > > ... > > > > > > Now I want to use a Program/site to put the names > > in > > > the right field. So each field is seperated by a > > > space as shown above. I have about 1000 entries > > to > > > put in and don't think doing each query per line > > is > > > going to be a 5 min job, any suggestions? > > > > > > Thanks! > > > > > > Find local movie times and trailers on Yahoo! > > Movies. > > > http://au.movies.yahoo.com > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: > > http://www.php.net/unsub.php > > > > > > > > > > Find local movie times and trailers on Yahoo! Movies. > http://au.movies.yahoo.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
