Re: Is it possible to use several statements in one query?

[Bill Karwin]

I can think of two options. You could do this with a multi-table UPDATE instead of subqueries:

UPDATE Table
JOIN Table2 ON Table.ID = Table2.TableID
JOIN Table3 ON Table.ID = Table3.TableID
JOIN Table4 ON Table.ID = Table4.TableID
JOIN Table5 ON Table.ID = Table5.TableID
SET
T2 = Table2.smth,
T3 = Table3.smth,
T4 = Table4.smth,
T5 = Table5.smth
WHERE ID=?

You can also set a user variable, and then use it in a subsequent statement, as long as you do both statements in the same database connection.

$h->do('SET @id = ?', {}, 100);
$h->do('UPDATE ... WHERE ID=@id');

Be careful about using double-quotes vs. single-quotes.
Perl interprets @id as an array variable if it's in a double-quoted string.

Regards,
Bill K.