Questions tagged as 'mysql-workbench'

Tagged questions
3
answers

Create database on the server via mysql-workbench template (.mwb) via command line

I'm trying to build a bat to create the database in the mysql server from a mysql-workbench EER (.mwb) model, that is, in command line, is it possible to perform this process? Could someone give a light? Editing: Opening it in cmd I have...
asked by 02.06.2015 / 19:05
1
answer

Backup in MySQL WorkBench

I need to make a modification to the database. I would like to know how to back up MySQL WorkBench, and how do I restore it in case of errors. Also if possible I would like some good habits tips to accomplish this kind of task, and some tips!...
asked by 28.04.2015 / 20:06
4
answers

What SQL statement to show the maximum number of active connections to the MySQL database?

What SQL command returns the number of active connections to the database?     
asked by 04.09.2015 / 19:48
1
answer

Improve the performance of a query

How could I improve this query, which returns me the top 10 sales to assemble a chart, so that it processes faster? set @startDate :='2015-01-03'; set @endDate :='2015-05-31'; set @dst_id:=1; SELECT SUM(vnd_quantidade) as quantidade, (S...
asked by 29.06.2015 / 14:25
1
answer

What is the shortcut in the workbench to execute the whole script [closed]

I know the shortcut to execute a line is ctrl + enter. But so far I have not found the shortcut to run the whole script.     
asked by 20.11.2015 / 04:17
1
answer

Doubt in MySQL table relationship Workbench

Hello, I have a small problem creating a database. My goal is to create a table to mark the attendance of people in the classes of the courses in which they are enrolled. The 'presecas' table should contain the id of the person, the course...
asked by 13.10.2015 / 02:51
1
answer

Is it possible to create a foreign key from another database?

I want to reference a foreign key from a different bank, I have seen in some forums that it is only necessary to 'nome_database'.'nome_tabela' , but it is not working. My code is as follows: ALTER TABLE 'relatorio_gestao'.'usuario_setore...
asked by 25.04.2014 / 21:30
1
answer

MySQL Workbench with autocomplete with all columns in the database when using table aliases

I noticed that after I installed a new version of MySQL Workbench autocomplete brings columns of all tables, this when I use aliases for table, when I repeat the table name autocomplete works normal. The problem is that sometimes the table name...
asked by 31.07.2015 / 04:15
1
answer

Problem Migrating MySQL Database to SQL Server

I am not able to migrate a database from MySQL to SQL Server, using Database Migration from MySQL Workbench. In SQL Server Server authentication, it uses login sa, I have already tried to reset the login password, but I could not. I also trie...
asked by 19.08.2015 / 06:47
2
answers

MySql WorkBench Relationship Doubts

I'm new to the forum and can count on your help on a MySql Workbench issue. I did a little modeling to explain my doubt. I would like to understand why, when relating a table that already has a foreign key, WorkBench generates in that t...
asked by 08.11.2016 / 23:14