I'm trying to make an query in the MYSQL database, but the query is not coming back what I wanted. I want to make a query where I return all modules and modules that the company has with the where clause in Empresa_ID .
MySQL Att...
Hello, I'm creating a database and I need to create some compound indexes to optimize the bank's processing. The problem is that I do not want to have to name those indexes one-by-one. Normally, I create a table as follows:
CREATE TABLE Usua...
Good morning! maybe it's simple my question, but ... I would like to know how to add primary key in a table not being at creation time (CREATE), I know that when accessing the table in "object explorer" in the "design" option it is possible with...
I have the following tables: conteúdo , aulas , curso , turma , grupo_User where the logic will be as follows:
A content can belong to several classes, as a lesson can have several contents
A class can belong...
Hello,
I am building a calibration tool (given a checklist the user needs to select the fields that agree (or not) with a link or script.
Ex.:
1)Colaborador inicia o atendimento conforme diretrizes.
a) conforme
b) não conforme
c) não se apli...
I'm having a problem printing the MySQL data in Eclipse. When I put to print the list of the registered data it is printing 3 times each information.
I know where the problem is, but I can not see the solution. My database has a schema and...
Hello, I'm trying to get a data but I'm not able to filter it the way I need it, for example:
select a.cod, a.nome, b.pedido, b.versao from cliente a
inner join pedido b On a.cod= b.cod
order by b.pedido
Now the problem one version has mor...
I have a PLSQL code: in which I get two values one numeric and another varchar.
Code:
create or replace FUNCTION hospitalTeste123(MatriculaMedico in number, nomeSchema in varchar2 ) return varchar is
type Tmedicos is record(
matM...
I need to perform a Insert in the database if there is no person's cpf. if it exists it has to do a Update . But all this through a single script in MySql . I have illustrated the example below as I am doing today:
1 If the cpf of the...