Possible to View Value of Script Variable in MySQL Query Browser's Script Window?

Posted by Eric J. on Stack Overflow See other posts from Stack Overflow or by Eric J.
Published on 2010-06-12T17:10:27Z Indexed on 2010/06/12 17:12 UTC
Read the original article Hit count: 124

Filed under:

mysql-query-browser

When stepping through a script in MySQL Query Browser's script window, is there any way to view the value of a variable I have just assigned?

Specifically I do an update on one line, and then:

SET @Num=row_count();

While debugging the script, I would like to be able to know the value of @Num

Related posts about mysql-query-browser

MySQL Query Browser How do I enter NULL ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Stupid question: In SQL, I know I can do UPDATE TableA SET MyColumn=NULL But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/empty string) into the MySQL Query Browser with no success. >>> More
Cannot Install mysql-query-browser in Ubuntu 12.04

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Please help..... I tried to install mysql-query-browser in my Ubuntu 12.04 GUI, I get the error message: Updating mysql-administrator installation paths... ./mysql-administrator: 59: ./mysql-administrator: cannot create /opt/mysql-gui-tools-5.0/lib/pangorc.bak: Permission denied Error updating… >>> More
Trying to Set Up SSH Tunneling To MySQL Server for MySQL Query Browser

as seen on Super User - Search for 'Super User'
I'm trying to set up SSH tunneling on a remote web server to another MySQL server so that the database can be browsed easily with MySQL Query Browser. I'm following this page but cannot connect to the MySQL server. http://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/ What… >>> More
Executing Line/Multiple Lines Only in mySQL Query Browser

as seen on Stack Overflow - Search for 'Stack Overflow'
I already used Microsoft SQL Server 2005 and found really easy to execute single/multiple lines of an sql query. Example: insert into tablea ($vala, $valb, $valc) values ($vala, $valb, $valc); insert into tableb ($vala, $valb, $valc) values ($vala, $valb, $valc); How can I execute the second… >>> More
How to get a table creation script in MySQL Workbench?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am rolling back to MySQL GUI Tools' MySQL Query Browser since I can't find the shortcut to get a table's creation script in MySQL Workbench. >>> More

Developer IT

Possible to View Value of Script Variable in MySQL Query Browser's Script Window? - Developer IT

Possible to View Value of Script Variable in MySQL Query Browser's Script Window?

mysql-query-browser

Related posts about mysql-query-browser

MySQL Query Browser How do I enter NULL ?

Cannot Install mysql-query-browser in Ubuntu 12.04

Trying to Set Up SSH Tunneling To MySQL Server for MySQL Query Browser

Executing Line/Multiple Lines Only in mySQL Query Browser

How to get a table creation script in MySQL Workbench?

Categories cloud