Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Mysql workbench tcp / ip over ssh vagrant

I am trying to create a java environment in vagrant, I installed mysql and I am not able to connect to mysql from my vm by my workbench on the host. This key I am using is exactly the same one I use in putty via ssh and that's right. I also used...
asked by 18.09.2017 / 21:46
0
answers

How to make selections through the Workbench Diagrams?

I'm migrating to Mysql WorkBench and I need to perform a relationship between SELECT... INNER JOIN... LEFT JOIN... tables, but I wanted to perform through the Diagrams schema. How can I proceed in this case?     
asked by 06.09.2017 / 21:19
1
answer

MySQL query problems

I am having difficulty querying between 4 tables, being them. States > Municipalities > Deaths > Population The query is returning the value of the population with a higher than true number ... Can anyone help me with this query? se...
asked by 05.10.2016 / 21:43
0
answers

Mysql Workbench 6.3 does not change the attribute data type in the table, always returns to the previous [closed]

Does anyone use the Designer Mysql Workbench tool in version 6.3? I'm having difficulty changing a datatype of a given attribute whenever I change it and I enter it back to the previous attribute ... Does anyone have the same problem? I think I'...
asked by 06.05.2016 / 02:40
2
answers

How to make MySQL accept a number of type 1.457,40?

I'm developing an application that needs to automatically export excel spreadsheets to the database. I'm using MySQL, but the spreadsheet data is not all well formatted the way the bank accepts it. I have already set as utf8_general_ci...
asked by 06.03.2018 / 14:18
2
answers

Count IF MySQL Workbench

I have a table that has an ID field. ID 1234 1234 1235 1235 1235 1236 And I would like to get the following result via query: ID ID_Counter 1234 2 1234 2 1235 3 1235 3 1235 3 1236 1 Where in the second column the fie...
asked by 02.02.2017 / 12:50
1
answer

MySQL Workbench - error unserializing grt data [closed]

I'm having an error opening a project in MySql Workbench. error unserializing grt data     
asked by 20.10.2016 / 17:12
3
answers

Multiple foreign keys coming from the same table. It's possible?

I am studying MySql using MySql Workbrench to create a diagram of my database and the following situation arose: Imagine I have the table_A and the table_intensity, where: Structure of table_A: id, name, intensity_1, intensity_2 Structu...
asked by 15.04.2015 / 20:39
2
answers

Problem 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: statuz varchar I need to update only the "statuz" field in my table.    * change the value from "NEW" to "...
asked by 27.06.2015 / 09:00
1
answer

Assign null value to a field

I was doing some testing on 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 that field. How can I do this?...
asked by 05.05.2015 / 20:08