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"
To:
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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org