Good,
I'm trying out a select box taken from this example link works perfectly but when trying to filter the results typing for example Águeda the result is null just accepting Agueda, can anyone help me to convert the search so as to ignor...
I have the following table in MYSQL:
cavalo - 2016-01-15
cachorro - 2016-01-16
gato - 2016-02-23
coelho - 2016-02-24
ovelha - 2016-03-21
tatu - 2016-03-22
I wanted to give a SELECT and show it this way:
JANEIRO - 2016: cavalo cachorro
FE...
Talk about it!
It is as follows, I have a dynamic page where the elements of the selects are loaded via Ajax according to the elements previously selected in other selects, for example, when you select the City in a select and the town combo l...
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...
Hello, I'm trying to populate a select with the options that are returned, according to what the user selects in a particular select.
The problem is that I'm a layman with jquery and I do not know if I'm doing it properly.
In my select I call...
I need to do UPDATE in an (office) field of a database (investor) database (b2c) on my site.
However, this UPDATE will depend on a SELECT query that is made in another database from another site (both sites belong to the same company). The two b...
I've set up a series of SQL but I'm having difficulty generating something that stresses less the server, I ask for help from you.
Follow SQL:
SELECT '2015-06-10 00:00:00' AS 'Hora', COUNT(id_contato) AS 'Total' FROM contato WHERE data_hora...
I have a table in SQL Server that makes the control of messages to be sent and a routine in C# , configured in a Cron, that selects the pending messages, sends and marks as sent.
What I'm implementing is the ability to configure...
I need to create a SELECT that contains only records of an x value onwards. For example, returning only movies with number of copies greater than 5
My Select
router.get('/filmes', (req, res) =>{
execSQLQuery('SELECT IF(copias >...