Re: plain-text file (.txt) to mysql database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux