Has anyone had this problem? I deleted a column in the table editor and then went back to MySql Query Browser but the edit button was disabled. Can't seem to figure it out and I hate MySql's forum format so i decided to ask here. Any help is greatly appreciated!
...
If you execute a query you get line that looks like this:
658 rows fetched in 0.0110s (0.0003s)
What does the numbers in parenthesis refer to?
I assume the 0.0110s is how long it took to run the query
...
Can the MySQL Query Browser set parameters of a parameterized query? If so, how? I tried populating the Parameter Browser tab but it doesn't seem to actually set parameters when I execute the query.
I searched for quite a while in Google (e.g. mySQL Query Browser parameterized) but had no luck finding the answer.
I found this threa...
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.
...
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.
...
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
...