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
-
0
votes2
answers54
viewsDecreasing the value of two fields of a table and sorting according to the result
I have the field "killed" and "died" in the table, I need to make the order of the results come as the decrease of these two values, Example: My query is like this: $woes = DB::table('woeplayerrank…
-
0
votes1
answer43
viewsError accessing RDS database with Heidsql
I get an error message when entering the Amazon RDS database: The access data is correct and the seat is spinning. Is there any procedure to be done to access the RSD database in Heidsql ??…
-
0
votes0
answers944
viewsMysql-Workbench giving dump error
I’m working with Mysql-Workbench, but when I’m going to dump (import/export), He gives a mistake, looks at the image below, knows how to solve ?…
-
0
votes1
answer589
viewsExport Sqlite to Mysql
I used Sqlite for a project, with it it is possible to create a database with format '.db' and see inside and everything else. Would it be possible to export in Mysql a database file created in the…
-
0
votes1
answer56
viewsHow to make Join 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:…
-
0
votes1
answer811
viewsERROR 1215: Cannot add Foreign key Constraint (Mysql Workbench)
Hello I am trying to add a foreign key to a table but I get error 1215. I have already checked the attributes and all are compatible, the portfolio field is a primary key, I do not understand why it…
-
0
votes0
answers918
viewsShow result grid in mysql Workbench
When running queries on my MYSQL Workbench, I cannot see the Result Grid, only the output screen saying whether there was an error while executing the command or not. How can I activate the Result…
-
0
votes0
answers39
viewsProblem with mysql workbeach
I have some databases running normally, Cro tables , procedures, and everything else normally. Everything works. Now I need to import a data modeling , so I’m going to file, open model , I open my…
mysql-workbenchasked 6 years, 4 months ago principiante dev 7 -
0
votes0
answers232
viewsERROR 1442 - Trigger AFTER INSERT - Mysql
My database has the following structure: CREATE TABLE BAIRRO ( BAI_COD INT(4) AUTO_INCREMENT NOT NULL, BAI_NOME VARCHAR(200)NOT NULL, CONSTRAINT PK_BAIRRO PRIMARY KEY(BAI_COD) ); CREATE TABLE…
-
0
votes1
answer380
viewsServices of Windows 10
Good afternoon guys, I’m having a problem with the Windows 10 SERVICE. I installed Mysql Server and Workbench to work with BD and Modeling however Mysql Server I downloaded is not compatible with…
-
0
votes1
answer206
viewsFluig - Mysql 8 Connector
I can’t get my Fluig server up, because there’s an error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed Exhaustively researching,…
-
0
votes1
answer474
viewsHow to enable mysql Workbench connection manually
I would like to know how to manually activate the connection in Mysql Workbench, without the aid of a command IDE like xampp. As I remember if I was making this connection via computer management,…
-
0
votes0
answers35
viewsMysql foreign key creation problem
I am trying to implement a 1:1 relationship between the Employee table and the User table, in Mysql Workbench, but when generating the Diagram I see that the relationship always remains at 1:n, even…
-
0
votes1
answer31
viewsWhy don’t you create Foreign Key?
I ran the commands in Mysql Workbench, but did not create the Foreign Key connection, which is wrong in querys? create table Computador ( ID int NOT NULL primary key AUTO_INCREMENT, Nome varchar(45)…
mysql database mysql-workbench foreign-key primary-keyasked 5 years, 5 months ago Felippe Jaqson Chemello 3 -
0
votes1
answer2565
viewsHow to know the date of each record that was entered in the database?
Good afternoon! I have a small database that stores the records of several people. Unfortunately no behavior was created to record the date and time of the record saved in the database. You can find…
-
0
votes0
answers87
viewsINSERT taking SELECT from two tables with WHERE - MYSQL
Hello! Follow my Insert and below I explain what is happening: INSERT INTO tab_relatorio_ext SELECT t1.CODIGO_EXT, t1.TIPO_EXT, t2.NOME_SITUACAO_EXT FROM Tab_Coletados_Ext as t1 JOIN…
-
0
votes0
answers955
viewsImport Excel data to Mysql
I am trying to make an import of an excel spreadsheet with 536 thousand records by mysql Workbench I saved the spreadsheet as csv but at the time of import it can import all lines but it pulls only…
-
0
votes0
answers158
viewsDefault Schema in Mysql
I followed the installation indicated on website mysql. After that, I installed Workbench also by following the command indicated on the official website. In college use Windows in Labs and there…
-
0
votes0
answers15
viewsWhile from the results of a select - PROCEDURE
Hi, I need to create a while inside a trial. I need to make a select before and from the records that this select return make an insert... Example: Query searching the data of a donor that is not in…
mysql-workbenchasked 5 years, 6 months ago user150060 1 -
0
votes0
answers43
viewsOptimize deletion of 700,000 records from a Mysql table
Hello, I am in urgent need of deleting 700,000 records on a table with just over 2 million. However, testing on the office server is taking hours because I need to filter a field and I will need to…
-
0
votes0
answers73
viewsError in Mysql sub-query in Workbench
Good morning! My code SQL is making the following mistake: Error Code: 1242. Subquery Returns more than 1 Row 0,000 sec The code is as follows:: SELECT DATE_FORMAT(FROM_UNIXTIME(data), '%Y') AS ano,…
-
0
votes1
answer1335
viewsError Code: 1062. Duplicate entry '2' for key 'PRIMARY'
I am trying to update the local table with the data from the cursoProunine table with the following command : Insert into local (idlocal, Uf, city) SELECT idlocal, uf_search, city_search FROM…
-
0
votes1
answer38
viewsDo Excel formulas continue to work after being imported into a Datagridview?
I have a spreadsheet in Excel where I import it, to present the data in a DataGridView, i wonder if the formulas that are contained in the spreadsheet still work in the DataGridView. To be more…
-
0
votes1
answer253
viewsMysql Workbench error setting foreign keys
I am wanting to create two foreign keys through Mysql Workbench and when I apply the information it executes the code below: ALTER TABLE `insect_db`.`usu_ins` ADD INDEX `fk_id_ins_idx` (`id_ins`…
-
0
votes1
answer18
viewsI made this code Join, I got it to return the expected values, but the values appear repeated. (Obs: I am beginner in Database)
select CLI_NOME, TEC_TELEFONE from tb_clientes join tb_tel_clientes on CLI_BAI_CODIGO = CLI_BAI_CODIGO where CLI_BAI_CODIGO in(2,3,4) order by CLI_NOME;…
-
0
votes0
answers27
viewsInsert into two tables obligatorily if not, rollback
I’m trying to make an error in trying to record, or for some serious reason in one and not serious in another, is performed the rollback in both tables, I found similar things, but I did not locate…
-
0
votes1
answer699
viewsConfigure Mysql in Docker container
When I take an SQL file of about 80 Mb and try to dump it in Mysql Workbench He gives: Error Code: 2006. Mysql server has Gone away My Docker-Compose configuration looks like this: version: "3.3"…
-
0
votes2
answers39
viewsShow data set with SELECT
Opa, then, I have a problem to find (show) some data that is being requested, I need to show the following data: https://i.stack.Imgur.com/ypczD.png and always appears the error that is an ambiguous…
-
0
votes0
answers161
viewsIs it possible to execute 2(delete,Insert) commands in a Stored Procedure - MYSQL?
Falling into the condition of if I need to execute these two commands: if(ultima_refeicao!=refeicao) then SELECT refeicao_alimentos.calorias into calorias from refeicao_alimentos where…
-
0
votes0
answers47
viewsError in creating FK
Operation failed: There was an error while Applying the SQL script to the database. Executing: ALTER TABLE prouni.ies ADD INDEX local_idx (local ASC) VISIBLE; ; ALTER TABLE prouni.ies ADD CONSTRAINT…
-
0
votes1
answer121
viewsColumn with utf-8 character error
When executing: SELECT campus_nome FROM cursosprounine where campus_nome like ('%?%')group by campus_nome; to check the character error, I found a code that taught me to convert the column: UPDATE…
-
0
votes1
answer85
viewsHow to condition select in another table row in Mysql?
I’m a beginner when it comes to Mysql language and I’m trying to filter some information I need to get out of a table. Basically I have data of individuals in consecutive years (2003, 2004, 2005)…
-
0
votes1
answer241
viewsHow to make a total disjunction in EER diagram? (Mysql Worckbench)
Hello, I need to deliver a sales system and I need to make the entity "payment form" one of these sub-classes (card, check, billet or deposit), only one per instance... How to represent the…
-
0
votes1
answer95
viewsI need to update the value of one SQL table with the sum of the values of another
I need to update the value of the column total_services of a certain number with the value (value value value * quantity) of the table nfpse_detail The command I’m using to try to do this is this…
-
0
votes1
answer38
viewsGuys, I have a question with Mysql about Procedures. Is it possible to save their return in a BD variable?
I have a repetitive process in BD that is validate the user for each request, so I decided to create a process for this and call inside the others when necessary. However I have the need to save the…
-
0
votes1
answer25
viewsMysql - Cross-table information (Selects)
I am trying to make a table that presents a set of elements, where if a given id is in another table, then that element cannot be in the first. Albums | id1 | id2 (Foreign Key)| Capas| id2 |…
-
0
votes0
answers18
views"WITH" is not valid at this position for this version of the server. Deploy to Heroku
I’m making a Deploy on Heroku of a personal project developed in PHP in which it is almost finished, however, I am having this error with a query of my project that is not running on the server, but…
-
0
votes1
answer28
viewsCalculate column
I want to calculate the column Rounds automatically, to get the last 10 games of the team understood? do not manage to do this with SELECT, I think it has to be in the creation of the table... This…
-
0
votes1
answer29
viewsit is possible to join one or more columns that have the same id in mysql
I have a customer table, a employees table, products, a sales table and a table to link sales with products. my doubt is when do I select SELECT idvendas,data_da_venda,valortotal,clientes.Nome as…
-
0
votes1
answer70
viewsError Code: 1136. Column Count doesn’t match value Count at Row 2
Good night, I’m making a table in Mysql Workbench where it shows data from an accounts receivable department, however I’m having a problem when I will enter the values it gives the error 1136 and…
-
0
votes1
answer99
viewsMYSQL - TRANSACTIONS
Good evening, I’m a beginner in mysql and I came up with the following question. When I make a transaction like this START TRANSACTION ; INSERT INTO PESSOA2(IDPESSOA,NOME) VALUES(NULL,'PEDRO2');…
-
0
votes0
answers33
viewsSystem using Java and Mysql Database does not recognize user and login even while in the database
I am making a Java Services Order System in Netbeans based in this course. I created the database in Mysql Workworkbench, created the user table, connected to the server in XAMP and made the…
-
0
votes0
answers9
viewsError when exporting a database using mysql Workbench 8.0
This is my first time using Mysql WORKBENCH, I’m having problems when exporting a database. In the image below are the parameters that I configured in the Data Export tab before starting the…
-
-1
votes1
answer38
viewsI can’t find the error of this Stored Procedure
delimiter $$ create procedure reposta(out mensagem varchar(100)) begin if new.codigo_veiculo != null then set mensagem = "Algum veículo está sendo utilizado"; end $$ delimiter ; error that appears…
-
-1
votes1
answer531
viewsAndroid Application and Mysql Database
I have an application developed on Android and need to connect to a Mysql database that is local on a Desktop. I can easily get the IP address of the machine where the bank is. How can I connect the…
-
-1
votes1
answer415
viewsBlack screen in Mysql Workbench
Linux Mint usage and when installing Mysql Workbench it looks like in the image. I’ve reinstalled, erased everything, downloaded other versions and got nothing...…
-
-1
votes1
answer203
viewsError accessing mysql Workbench using Docker-Compose
I’m starting to work with containers and I ran into a problem. Configure my Docker-Compose.yml file version: '3.3' volumes: data: services: mysql: image: mysql:5.7 ports: - "3306:3306" volumes: -…
-
-1
votes1
answer66
viewsSql, sum of several
Hello, I have a bank with 3 important tables, state,city and orders need to rank the states than have more requests to q have less but the orders are related only to city table. so I need to make a…
-
-1
votes1
answer178
viewsWorkbench shows error and does not connect
Workbench had stopped connecting, so I reinstalled it, but now the error is this, I have the xampp installed and it does not start mysql, already checked and has no active connection on port 3306, I…
-
-1
votes0
answers15
viewsI installed Mysql Workbench in Ubuntu but I click on the local server it gives this message of the figure below. In the terminal I can see the database
Guys I’m having a problem with my Ubuntu in the database. Someone to help me ? I installed Mysql Workbench but I click on the local server it gives this message of the figure below. However in the…