Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Error when creating a trigger

I'm creating this trigger DELIMITER // CREATE TRIGGER reposta3A AFTER INSERT ON utilizacao_veiculo FOR EACH ROW BEGIN SELECT emite_mensagem(); END// DELIMITER ; but when I run the show triggers command; it does not appear...
asked by 13.06.2017 / 17:22
0
answers

How do I make two references from one table into two tables?

Well, I have 3 tables tbl_users tbl_article tbl_profile I need tbl_usuarios to be related to tbl_artigos and tbl_profiles.  How could it be done? Tbl_users table: +-----------------+--------------+------+-----+---------+---------...
asked by 14.10.2016 / 23:37
1
answer

What is the error in the last row of UPDATE usage in the MySQL language?

I developed a final project without error, done in Java, but I still only have a UPDATE error in the last line of the database creation clientes of the database in the MySQL language. I am asking to update the data. public void a...
asked by 20.06.2016 / 18:16
0
answers

Export tables to CSV strange characters

When I export a table to CSV in MySQL Workbench, it has strange characters due to accent. Is there a way to resolve this? And also, how can I select all the tables I want and export to different CSV files (one for each table)? Thank you!...
asked by 24.06.2016 / 22:04
1
answer

How to import data (inserts) to a template (.MWB) in the workbench?

In the workbench I can insert data in the model individually by table of the form below, then when using the forward engineer just enable the Create Inserts in the SQL file that it generates, follows: But to do this for hundreds of table...
asked by 29.09.2015 / 23:00
1
answer

Query with two summations for the same column

Is it possible to do a query where two sums are executed on the same column in the same query? What I have is the following: Total sales sum select month(emitido_date) as mes, ifnull(sum((det.preco * det.quantidade) * (iva.valor/100) +...
asked by 11.08.2015 / 10:33
2
answers

I can not run the MySQL Server 5.2 Workbench [closed]

I'm trying to connect to the MySql Workbench 5.2 CE server to open a project in Ruby. But I can not connect to the server (local). The following error appears: Can not connect to MYSQL on '127.0.0.1' (10061) . I've tried some tutorials, but not...
asked by 01.05.2015 / 04:42
1
answer

Sql, sum of several counts

Hello, I have a bank with 3 important tables, state, city and orders I need to rank the states of the one that has the most requests to have less, but the orders are only related to the city table. so I need to make a count for each city and add...
asked by 10.09.2018 / 15:41
1
answer

WIndows Services 10

Good afternoon guys, I have a problem with the Windows 10 SERVICE. I installed MySQL Server and WorkBench to work with BD and Modeling because the MySQL Server that I downloaded is not compatible with what I am using in the Faculty, there we use...
asked by 09.10.2018 / 21:19
1
answer

Black Screen in MySQL Workbench

Use Linux Mint and when installing MySQL Workbench it looks like the image. I have reinstalled, deleted everything, downloaded other versions and can not get anything ...     
asked by 23.04.2018 / 15:44