There was a doubt that I thought would be easy, but the content I found I could not understand.
Good is as follows:
I have the tables
"Customer"
and
"ErrorsProducao_Ciente"
where they relate 1 to N, that is, 1 error can af...
I developed an employee registration system. In this system the persistence of the data is done in a mysql database. When I run the program through the package the system works normally, but when I run an executable jar it does not find the mysq...
I have two tables in my DB (mysql), where:
1st Table: CADASTROS
With the following fields: ID, NOME, IDADE, CIDADE
2nd Table: FUNCIONARIO
With the following fields: ID, ID_CADASTRO, PROFISSAO, SALARIO
Running...
Hello, I have two banks BDMCOM1 and BDMCOM1_V3_ALEA, both of which have a table named ProductDrive and the field called CodigoProduct, in the database table BDMCOM1, theProductDocument has 5 digits, in the table of the other bank theProductDocume...
I have a simple question but I could not find a solution.
In the same way I can when I use select to bring an empty column using select a.x,NULL as y,a.z from DADOS a , how can I make a column instead of having only NULL ,...
I have 6 SQL codes and all search the same table, it looks like this:
+-----+-----+-----+
| A | B | C |
+-----+-----+-----+
| 1 | 1 | 1 |
+-----+-----+-----+
| 2 | 1 | 5 |
+-----+-----+-----+
| 3 | 2 | 3 |
+-----+-----+...
I'm starting my journey in programming and I came across a mistake
in creating the MySQL database:
1005 - Can not create table 'mydb.provider' (errno: 150)
What will it be? I have already logged into several forums but this same error...
In the example below, I'm interested in removing duplicates of the rows in columns title and time without worrying about the other columns.
In the example below I'm interested in having the query return rows 32, 34 and 36 and al...
I have a table that has many records and a column called posição .
It only receives the value 0 for blocked and 1 for released.
Now with a precise change, invert these values, where this has to be 1 and where this 1 has to be 0.
H...