Two ways: - full path (like "c:/temp/data.txt") - simple file name: MySQL will assume the file is located in the current database data directory (like d:/mysql/data/my_database) _________________________ ----- Original Message ----- From: "JeRRy" <jusa_98@xxxxxxxxx> To: "Ignatius Reilly" <ignatius.reilly@xxxxxxx> Sent: Monday, March 01, 2004 11:15 Subject: Re: plain-text file (.txt) to mysql database > Hi, > > Right now I understnad. Thanks for the example. :) > > As for data.txt ... Where should I pop this on my > server? In the root of my account? (e.g. ~/data.txt > ?) > > J > > --- Ignatius Reilly <ignatius.reilly@xxxxxxx> wrote: > > 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" <jusa_98@xxxxxxxxx> > > To: "Ignatius Reilly" <ignatius.reilly@xxxxxxx>; > > <php-db@xxxxxxxxxxxxx> > > Sent: Monday, March 01, 2004 10:44 > > Subject: Re: 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 <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 > > > > > > > > > > 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
