Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Mysql error 1215: Unable to add foreign key constraint

How do I resolve this error? I know that one reason for this is that the columns must have the same size and specification. But I've tried everything and it's not working. CREATE DATABASE'sistema'/*!40100DEFAULT CHARACTER SET utf8*/...
asked by 07.06.2015 / 17:37
0
answers

Problem connecting a database

I was able to solve some of the problem. The error that I put below, in the initial part, was giving of my service of the mysql to be stopped. I do not know how, but somehow, after I started by WAMP, it stopped. After I started again,...
asked by 02.12.2018 / 03:46
0
answers

Mysql Workbench - Add to the Database new table of the EER Model (Forward Enginner Options)

I have web software that is already running and with the populated tables. But in the model and business rule I needed to insert one more table ... great than the project that is growing .... the question is this: Can I use the MysqQL Workben...
asked by 23.11.2018 / 15:21
1
answer

how to select last record from mysql table with last or another command

How to select last record of MySql table with last or other command For example: select last registro from tabela where coluna =23; I've tried this code but it did not work.     
asked by 17.09.2016 / 00:52
1
answer

How to reinstall Mysql Workbench in Ubuntu 16.04?

Recently I updated Ubuntu from 14.04 to 16.04 and after the update, which did not show any errors, the Mysql-Workbench application that was installed disappeared and even after trying to update the command has the following output. Command:...
asked by 13.08.2018 / 19:41
0
answers

Problem in creating foreign keys MySQL

I'm trying to implement a 1: 1 relationship between the Official table and the User table in the MySQL Workbench, but in generating the Diagram I see that the relationship always stays in 1: n, even with the UNIQUE constraint on the foreign key....
asked by 22.07.2018 / 19:32
0
answers

Convert charset Latin1 to Utf-8 at column level

I have a huge bank in Latin1 and I need to convert ALL the values of ALL the columns of the bank. Searching discovered a command that does this manually. UPDATE tabela SET coluna = CONVERT(cast(CONVERT(coluna USING latin1) AS BINARY) US...
asked by 18.07.2018 / 18:38
0
answers

SonarQube 7.2 + Xampp "java.io.IOException: An existing connection was terminated by the remote host"

I'm trying to create the connection between SonarQube 7.2 , using Xampp 3.2.2 to create and manage the database. When running StarSonar.bat it closes alone. When you start StartSonar.bat , the CMD returns a message with the fo...
asked by 05.07.2018 / 16:55
0
answers

Show result grid in mysql Workbench

When executing queries in my MYSQL WorkBench, I can not see the Result Grid, just the output screen telling me if there was an error executing the command or not. How can I activate the Result Grid tab to view the table? Follow the print f...
asked by 28.06.2018 / 06:02
0
answers

Problem with mysql workbeach

I'm having some databases running normally, cro tables, procedures, and everything else normally. Everything works. Now I need to import a data model, so I go to file, open model, open my template and when the workbench will load, the message...
asked by 06.07.2018 / 02:34