MySQL Forums
Forum List  »  Newbie

Re: Problem regarding variables in query browser
Posted by: Arie Nagel
Date: August 18, 2005 03:05AM

You can't do two commando's at once in the query browser's query tab. If you want to do that you have to use a script tab.

Unfortunately the script tab doesn't return any results so, if you want to be able to see the result, you would have to store that in a table and then use a
query tab to select the contents of the table:

script-tab
---------

CREATE TABLE foo(
col1 INT(10)
);

set @a=5;
INSERT INTO foo VALUES (@a);

query-tab
---------

SELECT * FROM foo;

Options: ReplyQuote


Subject
Written By
Posted
Re: Problem regarding variables in query browser
August 18, 2005 03:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.