In code, it looks something like this:

my $sql = "insert into foo (name,value) values (?,?) returning id into
+ ?";
my $sth = $dbh->prepare($sql);
$sth->bind_param(0, $name);
$sth->bind_param(1, $value);
$sth->bind_param_inout(2, \$id, 1024); # this is a reference that gets
+ written to!
$sth->execute;
print $id; # or whatever... $id has been written into by the execute
[download]

Granted, doing individual calls to bind_param / bind_param_inout is kind of painful and ugly, so when I do this I actually written a wrapper around calling all the binding, but this is the crux of what it does / how it works.

------------
:Wq
Not an editor command: Wq
[download]