Fw: Several statements in one query

I've figured out, that if i execute that statements one by one, i can get 
result that i want.
But there is no sense to use:
SET @a = SELECT ID FROM Table1 WHERE smth=?;
INSERT INTO Table2 smth_id VALUES(@a);
...

----- Original Message ----- 
From: "Alexander" <[email protected]>
To: <[email protected]>
Sent: Monday, June 12, 2006 12:10 AM
Subject: Several statements in one query


SET @a=1;
SELECT @a;

Works in phpMyAdmin. But does not work in perl. Where can be the problem?

Alexander 


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]