Questions tagged as 'mysql-workbench'

Tagged questions
2
answers

Mysql WorkBench Import and Export

I have a Bank in MySQL Workbench with the data filled in and I want to pass this all filled-in data to another MySQL Workbench, but on another computer. Is it possible to do this, or will I have to populate the data all over again?     
asked by 23.04.2014 / 19:19
2
answers

I can not insert 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 VARCHAR(2000) NOT NULL, TipoUtilizador VARCHAR(2000)...
asked by 20.05.2016 / 20:10
3
answers

How is the join and WHERE with multiple tables made?

I have 4 tables they already have foreign key. aluno: id matricula username curso_id // referencia a id_cursos da tabela cursos, coluna id_cursos. cursos: id_cursos nome_cursos modulos: id_modulos nome_modulos cursos_id...
asked by 04.11.2017 / 14:57
1
answer

Is it necessary to relate the tables to a database?

I have a little knowledge about the database and I know how to use JOIN for certain SELECT s. I'm setting up a simple DB where I have absolute assurance that one table has no relation to another. Is required? Is there anything in...
asked by 26.09.2018 / 22:10
2
answers

'Sum if' in MySql workbench

I have a MySql database. 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 polite, would be sumif .. Select needs to loo...
asked by 08.11.2016 / 20:04
1
answer

MySQL Workbench Does Not Start

I have worked daily on mysql workbench. It turns out that out of nowhere, the tool has stopped working. I carry the icon and nothing happens. I have already tried restarting the computer as well as restarting the "MySQL56" service but no effect....
asked by 22.09.2015 / 14:23
1
answer

MySql Error Code: 2006

Good morning, I'm using MySql Bank WorkBeanch 6.3.5, the connection is ok, but when I do a simple select on any table it gives the following error: Error Code: 2006. MySQL server has gone away     
asked by 16.12.2015 / 13:33
1
answer

Why the "quotation marks" in the INT data?

In the MySQL Workbench , when we do not enter a record by query , and manually, when giving APPLY , the query is displayed before execution. Example of a query consisting of MySQL Workbench : INSERT INTO 'nomedobanco'.'tabela' ('id'...
asked by 13.09.2018 / 11:58
2
answers

MySQL Workbench Error "Unknown File Encoding"

I have a problem, I backed up my database, however when I load script into MySQL Workbench , I get a message saying: "Unknown File Encoding" IfIchooseutf8Igetthismessage: I can only open if I choose latin1 , bu...
asked by 26.06.2016 / 09:48
1
answer

Searching for objects in mysql

Good afternoon, I am using WorkBeanch 6.3 and I need to search the MySql database if a particular Column exists and what its Table, I also need to know if the particular Column is used in a Procedure or View, for example in Sql Server I do this;...
asked by 21.12.2015 / 19:13