Questions tagged as 'select'

Tagged questions
1
answer

Delete a Limit of Hibernate Records (Limit)

I'm migrating my WEB application to the Hibernate framework, however I have several SQL requests with very specific parameters. In one of these requests, I always need to include a new record in the database, delete the first 20...
asked by 10.11.2017 / 14:55
0
answers

datatables does not show the data with a query using JOIN. What to do?

<?php include('../conection/db.php'); include('function.php'); $query = ''; $output = array(); $query .= "SELECT i.Tipo as Tipo, c.Descricao as Descricao, c.Anexo as Anexo from tbl_instituicao as i JOIN tbl_conteudo as c ON i.Id_conteudo = c....
asked by 03.11.2017 / 10:29
1
answer

I want to recognize the cpf in the table, display a page with other data. Where am I going wrong?

   Warning: mysql_num_rows () expects parameter 1 to be resource, object given in C: \ xampp \ htdocs \ solidarity \ associates.php on line 15 My php code <?php include"conectar.php"; // RECEBENDO OS DADOS PREENCHIDOS DO FORMULÃ?RIO !...
asked by 31.10.2017 / 01:04
1
answer

How to Make Two or More Select Categorized in the Same Query

I need to get all the words with 'A' and play in 'WordsComA' and all with 'B' and play WordsComB, and can have C, D AND ... The closest until now was this, but funcioana only with the first. SELECT w1.wd as PalavrasComA, w2.wd as Palav...
asked by 22.09.2017 / 21:50
1
answer

Select record that contains result equivalent to a variable

I have a column in my mysql table, where it is called "positions", where several values in int are placed there, however, with the "|" of division. Example: 8 | 19 | 10 | 20 | And each number represents a category. I would like to do...
asked by 05.10.2017 / 18:15
0
answers

How to group 2 selects into one by differentiating them

I have a situation here I have two selects results that are ok but I would like to change the result to one of the selects. select sum (r.l.numero_exames_relacionados), estabelecimento_saude.nome_fantasia from r.l. left join r.e. on r.l.identi...
asked by 13.09.2017 / 20:29
1
answer

Separate values from a multi select into columns

On my system, I have a multi select as they may come in the image below: AndIdoanexportofthisvariableinthisselectSELECTREPLACE(p.Argautor,',',';')ASArgautorFROMjud_ProcessospLEFTJOINjud_ComarcascONp.ComarcaId=c.ComarcaIdLEFTJOINjud_Municipio...
asked by 26.09.2017 / 14:58
0
answers

Help to optimize an index in mysql

I have a relationship website and for years I've tried to optimize this query. Almost every day the site hangs because of it. User table structure CREATE TABLE 'usuarios' ( 'id' bigint(20) NOT NULL, 'nome' varchar(25) CHARACTER SET utf8...
asked by 26.07.2017 / 07:48
0
answers

How to display decimals only when they exist?

How could I do so that in my select the numbers would appear without decimal place when they are 00 and the decimal places appeared when they are different from zero. Example: I have 5 numbers returning like this: 16.00; 10.00; 3.14; 5.00; 13...
asked by 14.06.2017 / 23:15
1
answer

How do I manipulate data from a select created from jquery

I'm trying to get the values from a select that I've inserted through a jquery, and depending on the value it adds elements inside a div also created by that same jquery. The problem is that I can not get these values. This is the code where...
asked by 05.06.2017 / 20:05