Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Update a record if it does not exist or if

How can I verify if the registry exists and then update it if it does not exist that I insert it? I tried this, but it does not leave me. UPDATE tienda SET Campo1 = 'carro' WHERE ID = '123' IF @@ROWCOUNT = 0 INSERT INTO tienda VALUES ('coch...
asked by 05.06.2017 / 15:02
1
answer

Error 1826: Duplicate foreign key constraint name, I need you to help me see where the error comes from

Executing SQL script in server ERROR: Error 1826: Duplicate foreign key constraint name 'idPersona' SQL Code: -- ----------------------------------------------------- -- Table 'GlobalCompany'.'Proveedor' -- ---------------------...
asked by 13.12.2018 / 20:40
1
answer

MySQL Inner Join with null Id columns

I have a table where there are several related ids and using inner join I get the data the problem is that some records do not keep an id and I put value Null and when ago the select with inner join does not show me the data with null value T...
asked by 09.10.2018 / 19:49
1
answer

Is it good practice to create relationships in this way? [closed]

I give you a graphic example of what I am implementing, and I would like to know if this is a good practice. I explain. a customer can make many payments, but in turn a partner can also make payments, then, would he have to make a payme...
asked by 16.01.2018 / 16:18
1
answer

Migrate data from Database to different server database in MySQL?

good I have the following panorama I have a database called Mybase in which there is a table called mytabla on a server and I have another server where I have a database called Mybase2 in which there is a table called MyTabla2 equa...
asked by 13.12.2017 / 18:49
1
answer

How to fill a combobox in Netbeans with data from a table in mysql

They could help me fill out a combo box with the data of a table in mysql. The problem is that the table has a iD , a name and a unit. But when filling the combobox I need the names to appear; and when selecting one, what I really need is...
asked by 22.11.2018 / 19:47
1
answer

Error in MySQL query

Someone can help me, how can I not join the fields of a query, that is, I ask the question and if it is the same product instead of showing me the 2 rows shows me 1 but adding the 2, the I show you to understand. And this is the sentenc...
asked by 28.09.2018 / 19:14
2
answers

Error importing: Operation has completed with errors

I'm trying to make a model's forward engineer to pass it to SQL and it throws a syntax error, the message says that it was completed with errors, the error as I said is syntax, but if the same workbench does the script, does it? why do you get i...
asked by 12.09.2018 / 14:43
1
answer

add the sales of my sellers

I am working in a database that is not well structured and due to lack of time it is necessary to work like this, starting from this I want to know how to add the sales of my salespeople, and I managed to find out what amount did in each vein an...
asked by 23.08.2018 / 20:12
1
answer

Change engine in the database

Good I'm doing an API, I have the classes Person , Requisitoria and Debt ; I'm using
asked by 22.06.2018 / 16:24