Most voted "mysql-workbench" questions
Use this tag when the question refers to some resource, information, or problem relating exclusively to the Mysql database management IDE, Mysql Workbench. For questions related to the Mysql database itself, there are already more appropriate tags. Mysql Workbench is a visual tool for database architecture development, which provides data modeling, SQL development, and administration tools.
Learn more…164 questions
Sort by count of
-
8
votes3
answers2208
viewsCreate database on server via mysql-Workbench (.mwb) template via command line
I am trying to assemble a bat to create the database in the mysql server from an EER (.mwb) mysql-Workbench model, that is, in the command line, is it possible to perform this process? Someone could…
-
7
votes1
answer1641
viewsMysql Workbench with autocomplete with all database columns when using table alias
I realized that after I installed a new version of Mysql Workbench the autocomplete brings columns from all tables, this when I use alias for table, when I repeat the table name the autocomplete…
-
6
votes1
answer575
viewsBackup in Mysql Workbench
I need to make a modification to the database. I wanted to know how to backup in Mysql Workbench, and how do I restore it later in case of errors. Also if possible I would like some tips of good…
mysql-workbenchasked 9 years, 2 months ago GWER 2,242 -
6
votes1
answer742
viewsImprove 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 more quickly? set @startDate :='2015-01-03'; set @endDate :='2015-05-31'; set @dst_id:=1;…
-
6
votes1
answer9796
viewsWhat is the shortcut in Workbench to run the whole script
I know that the shortcut to run a line is Ctrl + enter. But so far I haven’t found the shortcut to run the whole script.
mysql-workbenchasked 8 years, 7 months ago MarlonJhow 645 -
6
votes1
answer3395
viewsError creating table with INDEX VISIBLE in Workbench
I created a diagram of a BD using Mysql Workbench and had it generated. But the following error happens when I run the query: Executing SQL script in server ERROR: Error 1064: You have an error in…
-
5
votes1
answer547
viewsIs it possible to create a foreign key from another database?
I want to reference a foreign key from a different bank, saw on some forums that it is only necessary to do `nome_database`.`nome_tabela`, but it’s not working. My code is this:: ALTER TABLE…
-
5
votes4
answers6626
viewsWhat SQL command shows the maximum number of active connections to the Mysql database?
Which SQL command returns the number of active connections to the database?
-
5
votes1
answer8555
viewsDoubt in the relationship of Mysql Workbench tables
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 must…
-
4
votes3
answers12958
viewsGenerate Excel with php query
I need some help. I have a query in php and Mysql and would like to add to this query the option to export the data also to excel. It is possible to do this with php? <div id="tabs">…
-
4
votes2
answers655
viewsProblem Migrating Mysql Database to SQL Server
I am unable to migrate a database from Mysql to SQL Server using Mysql Workbench Database Migration. In SQL Server authentication, it uses sa login, I tried to reset the password of this login, but…
-
4
votes2
answers1508
viewsI cannot enter the values in the table with auto_increment in the primary key
This is my table: CREATE TABLE Utilizadores( IDUtilizador INT NOT NULL AUTO_INCREMENT, PNome VARCHAR(2000) NOT NULL, UNome VARCHAR(2000) NOT NULL, Email VARCHAR(2000) NOT NULL, PalavraPasse…
-
4
votes2
answers799
viewsRelationship Doubts in Mysql Workbench
I am new to the forum and I count on your help in an issue that occurs in Mysql Workbench. I did a little modeling to explain my doubt. I would like to understand why when relating a table that…
mysql-workbenchasked 7 years, 7 months ago MTAugusto 53 -
3
votes3
answers9800
viewsMysql Workbench - Create Database based on EER Model (Forward Enginner Options)
Doubt: In Workbench I created the table in EER Diagram and now I want to connect to Hostname 127.0.0.1. The way I walk is Forward Engineer -> Next -> and then I have a lot of options, I have…
-
3
votes2
answers19115
viewsMysql Workbench Import and Export
I have a Mysql Workbench Database with the data filled and I want to pass this data all filled to another Mysql Workbench, but on another computer. Is it possible to do that or I’ll have to fill out…
-
3
votes4
answers15410
viewsMysql Workbench 6.1 CE no longer starts
I don’t know if anyone uses here, I tried to use for the first time, downloaded, installed and used the first time in a good, I found it super cool, created a database, tables, edited everything…
-
3
votes1
answer4973
viewsWhat is the difference between the relationship with "identification" and the relationship with "non-identification"?(Mysql Workbench)
I have been learning Database for some time and do not know the difference. I would very much like to know. On the Internet I found answers, but they are not very enlightening.
-
3
votes1
answer336
viewsMount SQL to generate a dataset and popular a Treeview
I have a database here and I want to mount an SQL to generate a dataset in Delphi and then popular a Treeview. The figure below shows part of the seat, but that is the general structure of it:…
-
3
votes1
answer3611
viewsMysql Workbench does not start
I have been working daily on mysql Workbench. It turns out that out of nowhere the tool has stopped working. I click on the icon and nothing happens. I tried to restart the computer as well as…
mysql-workbenchasked 8 years, 9 months ago Pedro Cunha 195 -
3
votes1
answer1262
viewsMysql Error Code: 2006
Good morning, I am using Mysql Workbeanch 6.3.5, the connection is ok, but when I make a simple select in any table gives the following error: Error Code: 2006. Mysql server has Gone away…
mysql-workbenchasked 8 years, 6 months ago hard123 2,329 -
3
votes1
answer444
viewsFind objects in mysql
Good afternoon, I am using Workbeanch 6.3 and I need to search in the Mysql database if a particular Column exists and what its Table, I also need to know if a particular Column is used in a…
-
3
votes1
answer3448
viewsMysql Workbench - error unserializing grt data
An error appears to me when opening a project in Mysql Workbench. error unserializing grt data
-
3
votes2
answers210
viewsSum if in Mysql Workbench
I have a database in Mysql. No_Pedido|Valor|Cortesia 123|1000|Sim 123|500|Nao 124|200|Nao 124|500|Nao I need to make a select that returns the sum of the value per request that is not courtesy,…
-
3
votes2
answers771
viewsMysql Workbench Error "Unknown File Encoding"
I have a problem, I backed up my bank, however when loading the script in the MySQL Workbench, I get a message saying: "Unknown File Encoding" If I choose utf8 get this message: I can only open it…
-
3
votes3
answers68
viewsHow is Join and WHERE made with multiple tables?
I have 4 tables they are already with Foreign key. aluno: id matricula username curso_id // referencia a id_cursos da tabela cursos, coluna id_cursos. cursos: id_cursos nome_cursos modulos:…
-
3
votes1
answer82
viewsIs it mandatory to list tables in a database?
I have a slight knowledge of the database and I know how to use it JOINfor certain SELECTs. I am mounting a simple DB where I have certainty absolute that a table has no relations with others. Is it…
-
3
votes1
answer111
viewsWhy the "quotes" in the INT data?
In the Mysql Workbench, when we do not enter a record by query, and yes manually, when giving the APPLY, to query is displayed before execution. Example of a query composed of the Mysql Workbench:…
-
3
votes1
answer45
viewsMYSQL 5.6 does not recognize the query as it should
Greetings! I’m building a query to pick all the times the value was 0 on a given day and the highest time of the previous day. The data in my database is similar to the data I put in SQL Fiddle.…
-
2
votes1
answer2336
viewsType of relations 1:1
'Cause when I was gonna remake the relationships in my table 1:1 1:1 -------- 1.1____ (With the dash in the middle but the straight line) What’s the difference between us?…
-
2
votes1
answer56
viewsHow to download a BD from the console?
I need to download a database on my machine, but it can’t handle Mysql Workbench. Is there any other program lighter than Workbench or which commands for me to download the BD I want?
-
2
votes1
answer2396
viewsConnect Mysql Workbench to Hostinger Server
Several times I tried to connect the Mysql Workbench to the database of my website hosted on Hostinger.com.br but always makes a mistake. From what I understand the access data I am passing are…
-
2
votes3
answers3569
viewsHow to find relationship and cardinality in Mysql?
The image below shows a relationship between two tables created from Mysql Workbench. What I need to know is how I can find this information inside the database. I need to know exactly what kind of…
-
2
votes0
answers198
viewsMysql Workbench 6.3 does not change the data type of the attribute in the table, it always goes back to the previous one
Does anyone use the Mysql Workbench Designer tool in version 6.3 ? I’m having a hard time changing a data type from a certain attribute, whenever I change and enter it back to the previous…
-
2
votes0
answers95
viewsHow to perform selects through Workbench Diagrams?
I am migrating to Mysql Workbench and need to perform a relationship between tables SELECT... INNER JOIN... LEFT JOIN..., but I wanted to accomplish through the diagram of Diagrams. How can I…
-
2
votes2
answers99
viewsMysql Workbench tcp/ip over ssh Vagrant
Guys I am trying to create a java environment in Vagrant, I installed mysql and I am not able to connect to my vm mysql by my Workbench on the host. This key that I am using is exactly the same one…
-
2
votes1
answer94
viewsProblems in Mysql query
I’m having difficulty in performing a query between 4 tables, being them. States > Municipalities > Deaths > Population The query is returning the value of the population with a larger…
-
2
votes1
answer350
viewsHow to concatenate a variable plus a message in the "Insert"?
Concatenate a variable and a message in the insert? Example: declare a int; set a = 2; insert into tb_usuario values ('a' + 'fez tal coisa');
-
2
votes5
answers412
viewsSave or not the commands used in Mysql
When you create a Mysql code and run, that code after running, do you need to save it or not? Or after running can you forget it? I’m talking about the commands that create table, update, insert,…
-
2
votes1
answer60
viewsView linked ID of a duplicate mysql record
I wonder if it is possible to show duplicate records and which id that they are duplicated. Table Example: I would like to display the duplicate names, but let him also inform me id along. I made…
-
2
votes2
answers69
viewsset Enum field to null in Procedure
I have a precedent that I receive some data and these may come empty up there all right, but when the field is Enum and I try to set as null gives data truncated error for column even the field can…
-
1
votes3
answers1488
viewsForeign Key in another database?
Doubt in Mysql... What are the possible problems that may arise when making a foreign key in different databases? Taking into consideration this type of foreign key and a View that fetches…
-
1
votes3
answers16929
viewsMultiple foreign keys from the same table. Is it possible?
I am studying Mysql using Mysql Workbrench to create a diagram of my database and the following situation arose: Imagine that I have the table_A and the table_intensity, where : Structure of table:…
-
1
votes1
answer3380
viewsAssign null value to a field
I was doing some tests in the local database, and for them I ended up modifying a field that was null, assigning a value to it. Now that I’ve done the tests, I want to re-assign the value null to…
-
1
votes1
answer1133
viewsError in connection with the database. Java + Workbench
Error in connection with bank. Can anyone help me? package conexaoprojeto; import java.sql.*; import javax.swing.JOptionPane; public class ConexaoProjeto { private final String Driver =…
-
1
votes2
answers6796
viewsMysql error 1215: Cannot add foreign key constraint
How do I fix this mistake? I know one of the reasons for this is that the columns need to have the same size and specification. But I’ve tried everything and it’s not working. CREATE…
-
1
votes1
answer78
viewsExport a search result to . Txt
I use Mysql Workbench. I would like to know how to save the result of a query in a txt file. and that is separated by tab, I have tried everything else of the right.
-
1
votes2
answers2695
viewsPerform backup automatico Mysql
I am using Mysql as DBMS, and when searching the internet a way to create a routine backup found that the old versions had a tool that no longer exists in the newer versions, I believe that those…
-
1
votes2
answers713
viewsProblem with UPDATE mysql
I have a problem executing an UPDATE command in my Database... My table has 2 columns: -Column 1: link (PK) varchar -Column 2: varchar status I need to update only the "statuz" field of my table.…
-
1
votes0
answers310
viewsMysql - Performance with 0% efficiency
My Mysql is very slow in queries, but these same queries made on the production server are fast. So moving here I found this screen as circled in red says that the efficiency is at 0% and production…
-
1
votes1
answer765
viewsHow to import data (Inserts) to a model (.MWB) in the Workbench?
In Workbench I can enter data in the model individually by table as below, then when using the forward Engineer just enable Create Inserts in the SQL file it generates, follows: But to do this for…