Questions tagged as 'query'

Tagged questions
0
answers

Syntax error in Informix database query

I made a prototype of a informix database in Access to optimize the construction of my queries. I use with MySQL and through some syntax adjustments I get a good one. But in%% of% I can not. I want to believe it's a little detail b...
asked by 06.09.2017 / 09:52
1
answer

Working days function

The query below in datediff is bringing the days difference correctly, but I only want to bring the amount of working days. I already have a working day function that excludes Saturdays, Sundays and holidays. But I'm having trouble put...
asked by 18.09.2017 / 15:33
1
answer

Date back in mysql

Good morning everyone! how do I, in a query in mysql catch dynamically generate the date referring to 3 months ago?     
asked by 28.08.2017 / 15:55
1
answer

Print dynamic query

I have a query on a system where the user selects the month and the corresponding records are shown on the same page. I want to print the result of the query but as the form sends via GET: <form action="" method="get" id='form-contato' clas...
asked by 21.08.2017 / 11:31
1
answer

Query user data

Hello, I would like to know if there is a possibility to query user attributes and display on the screen. To do the user registration I am using the member final plugin, which by default only displays the user's photo and login, however I want...
asked by 10.08.2017 / 16:12
1
answer

Slow Query - SQL Server 2012

The query below takes an average of 30 seconds to execute. I know that most likely it will be the various or and like , but I am looking for the log table and not always the id will be the same, for I used the like . How do I adjust this q...
asked by 07.08.2017 / 21:55
0
answers

Email search without domain

I am doing a query to receive various data from DB, which involves entering the email field, but I do not want to do searches that show emails because of the domain. For example, I have an email " [email protected] " With the following quer...
asked by 07.08.2017 / 13:52
1
answer

Query with NOT IN in mysql

I have 2 tables (official and official_situation). I need to bring the officials in their proper situations. The big x of the issue is not to bring some employees who are in some situations (exception). I have this query, but it still disp...
asked by 11.08.2017 / 02:17
1
answer

Create trigger between tables

I'm doing a job here and I came across a problem, our system is a home automation system using java and mysql . We created two tables for logs , the first one saving the device, user and the exact date that was turned on or...
asked by 15.07.2017 / 16:11
1
answer

Use two or more times While for the same Select?

I'm putting together a listing page and product output register and I'm having trouble pulling the information and doing the while a second time. Example: $sql_for = mysql_query ("SELECT * FROM cliente ORDER BY cli_nome ASC"); $sql_for2 =...
asked by 14.07.2017 / 00:14