I'm using the MySQL Workbench to run a duplicate data removal query. When I run the query for a very large table, because of the 600-sec connection limit of the Workbench, it results in Lost Connection. Even so, the duplicate values disappear. T...
I want to use this method, locally it works and returns what I want, when I send IIS it simply returns me on the last screen it shows error:
Within Service1.svc.cs I have this method:
public string envioPessoa() {
MySqlConnect...
I can not save sentences or words with special characters ('&').
My bank looks like this:
ALTER DATABASE 'bancodedados' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
All fields in utf8 and utf8_general_ci right ...
It simply does...
I made this question from link and the problem that I was having was solved.
But I still can not enter data into the database.
connection.php
<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = ""...
I have a problem when passing a date to a select. Using the form below, select me normally returns the data:
SELECT H.* FROM HORARIOS H
WHERE NOT EXISTS (
SELECT * FROM RESERVAS R...
Hello, I have this code to show the categories menu:
require_once ('./funcao/conecta.php');
$conn = conecta();
$sql = $conn->prepare("SELECT * FROM 'loja'.'categorias' ORDER BY 'nome_categoria' ASC");
$sql->execute(array());
$sql->se...
I have had a peculiar problem while changing my Node.JS server to certain MySQL queries. I have the following code that works normally in MySQL Workbench:
SELECT id, nome FROM 'tabela' WHERE categoria <> 2;
But in node-mysql the query...
Hello,
In the following query, an error is encountered in the execution:
select
fto.id_taxon,
fto.cd_sexo as fto_cd_sexo,
fto.cd_idade as fto_idade,
x.ftv_cd_sexo,
x.ftv_cd_idade,
x.id_fv
from
tb_foto_oco...
I have the following problem:
I have a table in a MySQL database and in a code snippet I need to make content retrieved by a query made to this database be stored in a multidimensional array / array in php. The values of the two columns queri...
I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works.
The first file is:
<?php
include_once("/pasta/connectserver.php");
$table = "rjpsync_tag, rjpsync_i...