Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

MySQL Error - Stored Procedures

I'm creating this procedure to run once a day, as I have no experience, I got an error in the code below: CREATE (definer omitido) PROCEDURE 'MULTAOFF'() BEGIN set @multado = (select 'CPFAluno' from multa where 'dataMultaFim' &l...
asked by 07.11.2017 / 13:22
1
answer

How to hide undefined or validated variables after reloading the page?

I have 2 variables that get the values of an input type month , but when the code is executed for the first time ie when the page loads, the variables are undefined and the code takes the pc date. I would like to know if you can hide them,...
asked by 14.06.2016 / 14:35
1
answer

Bank connection error. Java + Workbench

Bank connection error. Can anyone help me? package conexaoprojeto; import java.sql.*; import javax.swing.JOptionPane; public class ConexaoProjeto { private final String Driver = "com.mysql.jdbc.Driver"; private final String Url = "j...
asked by 24.05.2015 / 05:54
2
answers

Relationship between tables

I have a certain table already created and populated: CREATE TABLE 'formulario' ( 'id' int(4) NOT NULL AUTO_INCREMENT, 'nome' varbinary(50) DEFAULT NULL, 'carteira' varchar(30) NOT NULL, 'tipo_ocorrencia' varchar(13) NOT NULL, 'conta...
asked by 20.12.2016 / 21:41
0
answers

Query mysql still running after Lost Connection?

I'm using the MySQL Workbench to run a duplicate data removal query. When I run the query for a very large table, because of the 600-sec connection limit of the Workbench, it results in Lost Connection. Even so, the duplicate values disappear. T...
asked by 22.02.2016 / 14:19
0
answers

MySql - Performance with 0% efficiency

My MySql is very slow in queries, but these same queries on the production server are quick. So moving here I found this screen as circled in red says efficiency is at 0% and production is at 99.8%. Can you increase the efficiency of my machine?...
asked by 02.07.2015 / 21:19
1
answer

Error accessing RDS bank with Heidsql

I get an error message when I log in to the Amazon RDS bank: Access data is correct and the bank is running. Is there any procedure to be done to have access to the RSD bank in Heidsql ??     
asked by 30.04.2018 / 21:02
1
answer

Error Code: 1406. Data too long for column 'txtContabilidade' at row 1

In MySQL .. I want to do UPDATE in a text field, it has about 300 characters and does not allow doing it, informed that it is too long. I have already tried changing the field type up to "Longtext", "VARCHAR (1000)" and did not allow it. Is t...
asked by 06.08.2014 / 20:24
1
answer

Export SQLite to MySQL

I've used SQLite for a project, with it it's possible to create a database with '.db' format and see inside and everything. Is it possible to export in MySQL a file with the database created in the same way as in SQLite? I use the MySQL Workb...
asked by 18.06.2018 / 18:29
1
answer

ERROR 1215: Can not add foreign key constraint (MySQL Workbench)

Hello, I'm trying to add a foreign key to a table but I get error 1215. I've already checked the attributes and all are compatible, the wallet field is a primary key, I do not understand why it's not possible to add the key. ALTER TABL...
asked by 18.04.2018 / 08:41