I need to make a select in a parent table, where all the children in this table NEED to be in the same situation.
For example:
In the parent table I have the following fields:
pai_id, pai_nome
In the child table I have the follo...
I have two different banks that I make the connection in the following way:
date_default_timezone_set('America/Sao_Paulo');
abstract class BancoDados
{
const host = 'localhost';
const novoweb = 'novoweb';
const WebAccount = 'Web_Account';
cons...
I would like to know how many records in my database, but do not return the quantity.
Look at the records in my database
SQLcommandSelectcount(*)ascontaRegistrosfromtb_produtoswhereprod_nomelike'%"+ +"%';
Result
I have a query in SQL Ansi:
select * from payments as P, receipts as R
where P.created_at < CURRENT_DATE AND P.updated_at < CURRENT_DATE AND R.created_at < CURRENT_DATE AND R.updated_at < CURRENT_DATE
Precious to perform the sa...
I am having the following problem, in a precise report displaying a field of the request that is as BLOB. And when I run the search it returns a strange code instead of the field information.
$sql = ibase_query("SELECT CAST(OBSERVACAO AS CHAR(...
I have this select:
select
DISTINCT (clients.name) as nomeempresa,
payments.amount_paid as pagamento,
receipts.original_amount as recebimento
FROM
payments,
receipts,
receipt_status,
payment_status,
clients
WHERE
pay...
The problem is the following, I have to bring from a select the permissions that a profile has, only the permissions are in a json field, and because if it is several permissions we have a data collection, I need to do this within a middleware:...
I received an exported Microsoft SQL 2016 file that has a .txt extension and the same file with .csv and looks like this:
I searched, but I still have not found anything, does anyone have any experience in importing this file into R?...
I have a validation problem with Login and Password, the code is only taken from the values of the first row of the database, but when I try to put the values of the other lines it gives error, thank you if anyone can help me. Follow the code be...
I am using a Schema in Oracle (sql developer) and within my schema there are already several tables created that I was using previously.
Now running a new script in this scheme it has the following error:
Relatório de erros -
ORA-00955: nome j...