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 [at] a = SELECT ID FROM Table1 WHERE smth=?;
INSERT INTO Table2 smth_id VALUES( [at] a);
....

----- Original Message -----
From: "Alexander" <zukoff [at] ukr.net>
To: <perl [at] lists.mysql.com>
Sent: Monday, June 12, 2006 12:10 AM
Subject: Several statements in one query


SET [at] a=1;
SELECT [at] 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 [at] m .gmane.org
Alexander [ So, 11 Juni 2006 23:48 ] [ ID #1351054 ]
Datenbanken » gmane.comp.db.mysql.perl » Fw: Several statements in one query

Vorheriges Thema: re-executing prepared statement leads to 'Modification of a read-onlyvalue attempted'
Nächstes Thema: Several statements in one query