I have two tables users and users_info , I would like to use foreign key, so when I create a record in the users table, create a record with the empty fields in the users_info table, only with the id_user complet...
Good afternoon!
Personal, in my table log has a field called logdescricao and in this field it stores several expressions. For example:
<log expressao="7085"><par traduzir="N">André Mariano da Silva</par><par traduzir="...
You have the bisemanas table that stores 26 fixed bi-weeks and the outdoor_bisemanas table that stores the billboards reserves according to the selected bi-week.
Edit : What I want is a select that displays all bi week...
How would a query make the selection between two tables according to the value of a specific column?
For example: I have two tables that contain account number and Balance, I need to know which accounts are not with the same balance.
Tab1...
How to insert into the table if the record does not exist, for example the table_materia_materia, has the following information:
+----+-------+---------+
| ID | turma | materia |
+----+-------+---------+
| 1 | 1 | 1 |
| 2 | 1...
I want to do this search below:
DECLARE @codccu VARCHAR(10);
SET @CodCcu = '63'
SELECT E.codepi,
E.numcad,
Max(E.datent) AS ENTREGA,
Max(E.datent) + P.diaval AS VALIDADE,
CA...
I have a table (quina) with 5 fields, each field can have the value of 1 to 80.
I would like to know if it is possible in SQL or only in Delphi, to get the dukes (combinations of 2 numbers) between 1 and 80 in the fields from c1 to c5. no mat...
I'm trying to make a Select with PDO and MYSQL, but when I put the php code doing this query in the middle of my html it does not allow the execution of the rest of the page.
follow the code snippet:
<select class="emselect">
&l...