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 <ignatius.reilly@xxxxxxx> 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" <jusa_98@xxxxxxxxx> > To: <php-db@xxxxxxxxxxxxx> > Sent: Monday, March 01, 2004 10:08 > Subject: 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
