|
|
Posted by C. on 12/12/06 12:57
applegreenss@gmail.com wrote:
> Is it possible to take the contents of a MySQL DB Table, and somehow
> put the data into a syntax-correct data file format like a delimited
> .txt file,
Yes - take a look at mysqldump, but it might be simpler to roll your
own.
> and using PHP parse it as a local c:\ file assuming it was
> sitting in C:\data.txt ..... so I want to read its contents in a
> similar method as you would query a DB table
Yes - IIRC there's an ODBC driver for CSV files (but the last time I
used it was about 10 years ago - maybe MS don't ship it any more).
>.... can you do this the
> same with a blob of data stored in a .TXT file?
>
Yes - but you'll need to encode it first. A better solution would be to
write each blob to its own file and reference the file from the table.
Although it is *possible* to do all this, it doesn't make a lot of
sense - a better solution would be SQLite or DBM.
C.
Navigation:
[Reply to this message]
|