Peter Rabbitson wrote:
> Hello everyone,
> I want someone to share his expertise on the following:
> Suppose we have a table with some data that periodically must be synced
> with an external source, which provides only partial information (e.g.
> it might provide all the fields for a new record,
Below is taken from: http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm
Also look at:
http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html
Prepared statement support (server side prepare)
To use server side prepared statements, all you need to do is set
the variabl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey Peter,
Are you sure about that?
As far as I understand, what you say you can't do, is to have two
prepares for example:
my $dbh = DBI->connect("dbi:mysql:database","user","pass");
my $foo = $dbh->prepare("SELECT * FROM .");
my $bar = $dbh->
> I'm sure others will give you more informed answers.. But why can't
> you create multiple statement handlers under the same connection?
>
Because you can't. One connection holds only one prepared statement (at
least in MySQL). If you prepare $statement2 on the same $dbh,
$statement1 automati
On Sun, Jul 10, 2005 at 06:23:19PM +0300, Octavian Rasnita wrote:
> Can't you use the replace sql query?
>
> Use it like you use "insert". It will insert new rows where there are no
> rows, and do an update where there are rows...
>
Negative. REPLACE is just a shortcut for DELETE FROM... INESERT
Can't you use the replace sql query?
Use it like you use "insert". It will insert new rows where there are no
rows, and do an update where there are rows...
Teddy
- Original Message -
From: "Peter Rabbitson" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 10, 2005 18:09 PM
Subject: DBI ins
