I have a Desk system in which I'm trying to connect to a database that stays on the server. But every time I try to connect it gives the following error:
java.sql.SQLException: null, message from server: "Host
'nco-inf-04.cop.com.br' is...
I would like to create a SQL using LEFT JOIN.
I did this SQL, but it did not work:
SELECT
*,
p.parametro AS cidade,
cpr.codTipo AS tipoAcompanhante
FROM
cadastroperfil AS cp,
cadastroprofissional AS cpr,
parametr...
I use a query that does the search in 3 different tables, return this query attribute in a Datatable that will fill a Datagridview .
The problem is that the search itself is a little time consuming, I used TOP as a limit...
I'm developing a system for storing documentation for day-to-day use with PHP and mysql, and to make it easier to query, I have added tags to these documentation and to ensure the integrity of the data I added another table called documentacao_t...
if (is_uploaded_file($_FILES["foto"]["tmp_name"])) {
$imagem = time() . '_' . $_FILES["foto"]["name"];
$diretorio = 'fotos/ {{{AQUI VIRIA O NUMERO DO ID }}}' . $imagem;
if (!move_uploaded_file($_FILES["foto"]["tmp_name"], $diretorio)) {...
I have the following query:
$string = "
SELECT DISTINCT(idClientes), nome FROM clientes WHERE idClientes IN (
SELECT idClientes FROM planosclientes WHERE idPlanosClientes IN (
SELECT distinct(idPlanoClientes) FROM pagamentos WHERE mesRefe...
I have a table named bairro :
Ihaveatablenamedtabelafrete:
I have the following SQL
public function getBairroList()
{
$sql = "SELECT * FROM bairro as b Left join tabelafrete as t on b.idBairro = t.idDestino where t.idSai...
The company has the base closure of "21 to 20" each month.
I would like to know how do I make SQL search only the records that are within the closing? Ex: my closing this month is: 05/21 to 06/06, but I do not want to get the last 30 days ... I...
I have a table in an access database with the following fields:
DATA | SALA | AULA1 | AULA2 | AULA3 | AULA4 | DOCENTE | TURNO
----------------------------------------------------------------------
02/02/2015 | S1 | 1 | 1 | 0...
How do I resolve this error? I know that one reason for this is
that the columns must have the same size and specification.
But I've tried everything and it's not working.
CREATE DATABASE'sistema'/*!40100DEFAULT CHARACTER SET utf8*/...