Re: [GENERAL] UPDATE cell from text file

On Sun, 24 Oct 1999, Jason C. Wells wrote:

> This has got to be easy but I am having a hard time finding the right
> docs.
>
> What I want to do is analogous to:
>
> UPDATE website SET content='contents of a big ass file that I dont want to
> type on the command line' where filename='index.html';
>
> How can I do this?
>
> Can I do this without writing a seperate shell and/or perl script?
>
> Also, is there a stdio stream that I can use to pipe data into SQL
> commands? Man, If I had this I could get a lot done in a hurry.
>
> FWIW, I am not looking for COPY-ing delimited data from a flat file into a
> table. I don't want to make new rows. I am trying to bring the contents of
> an entire file into an existing single cell (namely content) of a table.
>
> Am I going to be stuck just putting pointers to files in my database? Ugg,
> I really want ALL my data in one place.
>

Just out of curiosity, what's the drawback of a perl script here? It
would be pretty trivial.

....
open BAF, "$ARGV[0]" or die "Can't open $ARGV[0]: $!";
$contents = "";
while (read, BAF, $buf, 10240) { $contents .= $buf; }
$sth = $dbh->prepare("UPDATE website
SET content = ?
WHERE filename = ?");
$sth->execute($content, $ARGV[1]) or die $DBI::errstr;
....

--
Bob Kline
mailto:bkline(at)rksystems(dot)com
http://www.rksystems.com