Debugging mode in MySQL Workbench

When running queries in MySQL workbench, some of them are captured to the log file at either:

  • MySQL/Workbench/logs
  • MySQL/Workbench/sql_history

However, I’d like to see ALL the possible queries that MySQL workbench does. Is there a way to do this on the client-side, i.e., where MySQL workbench is running? For example, it would be nice to see how these graphs are being generated and the system data is being grabbed, etc.:

enter image description here

Wolfram Workbench Installation Issue

In attempting to reinstall Wolfram Workbench 2.0 after a unused hiatus and system reconfiguration, I downloaded both Eclipse and Workbench. Both seem to run. However, in following the Wolfram video on installing WWB Adam Berry suggests that before getting started one should Select the Help Menu and the Install Workbench Extras. Following the video I check the box for the single available feature Subclipse to add client support for SVN source control to the WWB. In pressing Finish I get the error:

“Could not connect to update site: http://subclipse.tigris.org/update_1.6.x”

Consequently, I can not perform subsequent steps as given in the Workbench Installation Video. It seems that the subclipse.tigris.org pages references are now missing and the site is decommissioning. Checking this subclipse.tigris.org website indicates it will be gone by July 2020,but you had to ask before 1 June 2020. The files referred to no longer seem to exist. For example, there is no “Team” support as suggested in the video.

How can one resolve this issue? Is it even necessary any longer to do this? If so, how can one now setup WWB to establish the setup features referred to in the video? If not necessary, perhaps the Installation Video needs to updated.

Define user variables to use in a SQL that has an “in” statement in MySql Workbench

I am trying to use defined variables in MySql Workbench I am using version 6.3 of Workbench I am trying to run ad hoc queries that can have a value or multiple values:

If I have a single value, the query runs ok set @Zdept_Id=”548″ and then Select * from employees where dept_Id in (@ZDept_Id)

but if I want to execute this for multiple departments, the query only returns values for the first number

set @Zdept_Id=”548,221,1973,905″ and then Select * from employees where dept_Id in (@ZDept_Id)

Dept_Id is an integer.

Thanks

PS. These are reports that I run once a month, so automating them is not an option due to cost/benefit.

Multiple Result Tabs in Workbench

enter image description hereI have several queries in the editor, each terminating with a semi-colon (I am teaching myself SQL and so in the editor is a mix of queries and notes like below):

SELECT * FROM orders WHERE order_date >= ‘2019-01-01’;

— AND operator

SELECT * FROM customers WHERE birth_date > ‘1990-01-01’ AND points > 1000;

— OR operator

SELECT * FROM customers WHERE birth_date > ‘1990-01-01’OR points > 1000 AND state = ‘VA’;

— NOT operator

— Exercise: FROM order_items table get the items — for order #6 — where total price is greater than 30

SELECT * FROM order_items WHERE order_id = 6 AND quantity * unit_price >= 30;


When I first began using MYSQL, I would run a query and only the last SELECT statement would run and the results would show in the result tab. The ACTION OUTPUT would show the time-stamp which clearly indicated only the last SELECT statement in the editor was run.

Now, all queries ending with a semi-colon are running simultaneously and each appears on its own tab and in the ACTION OUTPUT section on the bottom (i.e., “orders43”, “customers44”, “customers45” and so on.)

The only way I can get the most recent result is by highlighting the specific SELECT statement and running the query. However, I want to know why the results aren’t just “overriding” each other and the most recent SELECT statement being the results displayed in the same result tab…

At this rate, I’ll have hundreds of result tabs for each query ending with a semi-colon, and this is clearly not what I want nor was it how the workbench was working for me up until recently.

I am not sure why this is occurring, or how to stop it.

Any help would be greatly appreciated.

Thanks!

Disco dingo – mysql workbench – issue in installing

Disco dingo – mysql workbench – issue in installing

Getting following:

prashant@prashant-ubuntu:~$   sudo apt-get install mysql-workbench Reading package lists... Done Building dependency tree        Reading state information... Done Package mysql-workbench is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source  E: Package 'mysql-workbench' has no installation candidate 

In mysql workbench Debugging query I do not see result rows

Hello,
With mysql workbench 6.3 under ubuntu 18 when I want to debug some sql I click “Create a new sql tab for executing queries” toolbar item
and new tab editor is opened. When I click “Execute the selected portion…” toolbar item I see info on the sql executed,
but not result rows, as I expected : https://imgur.com/a/wnRKTUO.
1) Is it some hidden area?

2) I do not want to use all my databases on this connection, How can I hide some databases, without deleting them?

Thanks!

SPFX 404 When Trying to Get Current User In Workbench

I’m trying to get the user context in my React webpart and am getting 404’s when requesting: https://localhost:4321/_api/web/currentuser

This is the part of the code that fetches the current user:

private GetUserProperties(): void { /* pnp.setup({   spfxContext: this.context });  */  pnp.sp.web.currentUser.get().then((r: CurrentUser) => {   console.log('CURRENT USER', r); }); 

}

This was setup as a Sharepoint online application. I’ve tried several different solutions with no luck.

Error 1064 de MySql: creado con MySQL WorkBench

Estoy intentando exportar un modelo a mysql pero al momento de exportarlo me aparece lo siguiente en una de las tablas:

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘

INDEX fk_Ventas_Cliente1_idx (Cliente_idBecados ASC) VISIBLE,

INDEX `fk’ at line 11

        CREATE TABLE IF NOT EXISTS `mydb`.`Ventas` (           `idVentas` INT NOT NULL AUTO_INCREMENT,           `Fecha` DATE NULL,           `Hora` TIME NULL,           `Nota` VARCHAR(500) NULL,           `totalVenta` FLOAT NULL,           `Empleados_idEmpleados` INT NOT NULL,           `Cliente_idBecados` INT NOT NULL,           `Usuarios_idUsuarios` INT NOT NULL,           PRIMARY KEY (`idVentas`),           INDEX `fk_Ventas_Empleados1_idx` (`Empleados_idEmpleados` ASC) VISIBLE,           INDEX `fk_Ventas_Cliente1_idx` (`Cliente_idBecados` ASC) VISIBLE,           INDEX `fk_Ventas_Usuarios1_idx` (`Usuarios_idUsuarios` ASC) VISIBLE,           CONSTRAINT `fk_Ventas_Empleados1`             FOREIGN KEY (`Empleados_idEmpleados`)             REFERENCES `mydb`.`Empleados` (`idEmpleados`)             ON DELETE NO ACTION             ON UPDATE NO ACTION,           CONSTRAINT `fk_Ventas_Cliente1`             FOREIGN KEY (`Cliente_idBecados`)             REFERENCES `mydb`.`Cliente` (`idBecados`)             ON DELETE NO ACTION             ON UPDATE NO ACTION,           CONSTRAINT `fk_Ventas_Usuarios1`             FOREIGN KEY (`Usuarios_idUsuarios`)             REFERENCES `mydb`.`Usuarios` (`idUsuarios`)             ON DELETE NO ACTION             ON UPDATE NO ACTION)         ENGINE = InnoDB 

MySql Workbench keychain error on kubuntu

I installed MySql workbench on my Kubuntu install but when trying to test a connection to a DB running in a docker container I get the error message:

Remote error from secret service: org.freedesktop.DBus.Error.ServiceUnknown: The name org.freedesktop.secrets was not provided by any .service files 

I have tried running this from terminal as well as through the shortcut under applications.

I also attempted disabling gnome-keyring by editing the /usr/bin/mysql-workbench file but un-commenting the line that states

# Uncomment the following line if you're having trouble with gnome-keyring lockups. # This will cause passwords to be stored only temporarily for the session. WB_NO_GNOME_KEYRING=1 

This had no effect.

Edit: I installed DBeaver and managed to connect to the database without issue but cannot use this as its required that our team use MySql-workbench

Kubuntu version is (uname -a):

Linux TLHD-1661 4.15.0-55-generic #60-Ubuntu SMP Tue Jul 2 18:22:20 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux 

lsb_release -r gives

No LSB modules are available. Distributor ID: Ubuntu Description:    Ubuntu 18.04.2 LTS Release:        18.04 Codename:       bionic 

mysql workbench version 8.0.17 64 bit community version