I have a problem where select is bringing the right result, but it takes too long. Follow the select:
SELECT c.cod_paciente,
p.nome,
i.valor,
i.quantidade,
d.convenio,
c.cod_conta
FROM caddadosclinico d
INNER...
I made a registration to be inserted the cpf and email, the cpf I could validate right, to see if it works or not. But when it comes to the part of knowing if the email exists ... I researched a lot and saw a way, which is to send an email to...
I'm starting with Laravel 5.1 and I'm a bit lost yet.
I need to list categories, subcategories and "sub-subcategories".
Table:
Categorias
------------------------
id | int
nome | varchar
categoria_pai | int
Data:...
I would like to make a INNER JOIN between two distinct tables that are on the same server. Was it something like that?
INNER JOIN BANCOA.tabelaA.colunaA ON BANCOA.tabelaA.colunaA = BANCOB.tabelaB.colunaB
Remembering that I'm doing th...
I am not able to uninstall and run MySql 5.5 on my Ubuntu Linux 14.04.LTS, every time I try to access it, I get the following message:
ERROR 2002 (HY000): Can not connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'...
I have a problem here with Mysql, it is giving errors, I have made all kinds of changes. I have tried to change the Mysql function to Mysqli and only increase errors.
Code:
<?php
$sql["host"] = "localhost";
$sql["usuario"] = "ro...
Well, I created a table called installments, which when the customer pays it is entered 'PAYMENT' in the column situation, and when not paid it remains blank. I wanted to get the information from this column to know when the account was not pa...
Query :
INSERT INTO veiculo(nome,modelo,placa,ano)
VALUES('teste','testeModel','ASD5647',2012)
Fields:
nome | varchar
modelo | varchar
placa | varchar
ano | int
Error reported:
# 1264 - Out of range value for column 'yea...
How can I return a select the daily sum of the value column, being that before adding I have to do an average per hour? My table receives the "value" once per second, I need to average the hourly value of that value and return the sum of these a...
I created the following method to execute my querys:
public function setQuery($query) {
try {
$stmt = self::$conn->prepare($this->limpaQuery($query));
return $stmt->execute();
} catch (PDOException $Exception)...