Ed Reed wrote:
The command line interface allows you to run multiple commands at once. The Query Browser and PHP interfaces allow only one query per function call. So mysql_query('SET @A; SELECT @A;') would fail. You need to run each query separately.If I run the following in MySQLFront v3.1
Set @A='Test'; Select @A;
I get back same result
+------+ | @A | +------+ | Test | +------+
If I run the same query in MySQL Query Browser v1.1.6 I get this,
ErrNo 1060, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; select @A' at line 1
and If I run the same query in my application I get the same error as the Query Browser.
Anyone know how I can get my application to give me what I'm looking for?
This is certainly the case in your application, even if it's not PHP.
If you ran the queries separately in the Query Browser, you wouldn't get the results you expect. It would forget the value of @A because it closes the connection each time. It's possible to keep the connection open by Starting a transaction (even if you're using MyISAM tables).
Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
