ike
> d:/mysql/data/my_database)
>
> _
> - Original Message -
> From: "JeRRy" <[EMAIL PROTECTED]>
> To: "Ignatius Reilly" <[EMAIL PROTECTED]>
> Sent: Monday, March 01, 2004 11:15
> Subject: Re: [PHP-DB] plain-text file (.txt) to
> mysql database
"Ignatius Reilly" <[EMAIL PROTECTED]>
Sent: Monday, March 01, 2004 11:15
Subject: Re: [PHP-DB] 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
> ser
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
Hi Ricardo,
Yep that is why I asked for website/Program already
established. Don't have the time to do what is
mentioned as this is very urgent and needs to be done
quicker rather than later.
Short notice posting I know but anything is worth a
try.
Thanks for your suggestion.
J
--- Ricardo L
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 l
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-
I know this might sound a little bad, but i would use Perl or an editor that
supports regulars expresions to convert the data into insert statements and
after that i would use a database administration tool (ex. myCC) to insert
the data, you could put some statements before doing the inserts to dis
