Questions tagged as 'query'

Tagged questions
1
answer

Change language in the database during a query

Is it possible to change the language of the database only while executing an insert query? I am having problems with date conversion due to their formation, the Bank expects dd-mm-yyyy, but in the query is yyy-mm-dd.     
asked by 18.07.2014 / 21:23
1
answer

Java check, display the values registered in the MySQL database

I need help I'm doing a game in java and I need all the records and files and etc of the players in my table but I can not connect to the database much less check and display the values Ps: the Sun.java tutorial from DriverConnector did not h...
asked by 25.07.2014 / 14:13
1
answer

Execute a query when clicking the result of another query [closed]

I have the following column structure from my database: account_id, name and appearance. Image: link I had the following code before: <font size="3">Por favor digite o nome do personagem que deseja Resetar a Aparencia</font> &...
asked by 02.04.2015 / 13:01
2
answers

SQL QUERY get a month's average of a relative day of the week

I need a query that returns me the average of a relative month, and a day of the week. For example: I need to know the components for the month of February, the day of the week Monday. It is possible to define some expression for DATA ,...
asked by 02.04.2014 / 14:05
1
answer

How to make an appointment to know the averages of people per day a week

Hello, I would like to know how to query the Oracle database to know: What is the average number of guests per day of any given week. Here's the script for the bank: CREATE TABLE APP.HOSPEDAGENS ( hsp_id number(6), hsp_checkin...
asked by 05.12.2018 / 06:28
1
answer

Join in three tables does not show all results

SELECT * FROM produto_unidades join produto_notas on produto_notas.id = produto_unidades.produtoNota_id join produto_licitacoes on produto_licitacoes.id = produto_notas.produtoLicitacoes_id where produto_unidades.unidade_id = 2 The join work...
asked by 22.10.2018 / 19:44
1
answer

Query does not return values [closed]

None of my querys return values, and I have data in my bank. What might be happening in my code that is resulting in this? Follow the Code: <?php require_once("Usuario.php"); require_once("Conexao.php"); require_once("Crud.php"); class DaoU...
asked by 18.10.2018 / 14:16
1
answer

Search with date in Laravel

I have the following query:
asked by 02.10.2018 / 20:19
1
answer

Help with Join in Mysql [duplicate]

I found several questions / answers about join on the site, but I still can not create the command I need. What I need is the following: I have the following tables: item (I have two items registered) id descricao --------------- 1 - d...
asked by 06.08.2018 / 13:35
1
answer

Query Result to be Zero

Good afternoon, I have a question, could you help me? ... What happens is: I have a sql query that brings me the total amount of sms sent per month and year, but I wish when I did not get that month it shows zero in the field. because i...
asked by 26.07.2018 / 22:33