Questions tagged as 'mysql'

Tagged questions
1
answer

Add subquery values separately

I have a problem with this query below: select sum(tb1.l1) * 0.3, sum(tb2.l2) * 0.3 from ( select setor, total_geral as l1 from mobile.auditoria where month(data) = month(now()) and year(data) =...
asked by 18.10.2018 / 16:37
1
answer

Bring the sum of IDS and data into two tables using SQL

I need to make an SQL to swallow me the data of: 'DATA | QTDE IDTa | QTDE IDTb | VALORa | VALORb | Saldo (diferença de VALORa - VALORb) ' But I am not able to bring the data correctly with this SQL example: link I need to get out like...
asked by 17.10.2018 / 20:41
3
answers

How to upload image using Spring Boot?

I'm learning to use Spring Boot and I need to create a field in the form that loads the image to be used. How do I map the directory and save to a particular project folder? Example: Through the form, the user will load the photo. In...
asked by 23.10.2018 / 04:30
1
answer

Left Outer Join Pulling Only Contained Data

I'm trying to do this research to know how many children and pregnant women each visitor attends but is only pulling the families that have pregnant even putting the blessed LEFT OUTER JOIN , is because of the ON clause? I can not...
asked by 04.10.2018 / 16:54
1
answer

Querying inserts in the database in real time [duplicate]

There is a table in Mysql that suffers many insertions. The application needs to show these changes to the client. Currently the existing application queries the table every 10 seconds and displays the contents of the table. Is there any way t...
asked by 14.08.2018 / 15:47
1
answer

Sessions with PHP

I made a session code in PHP for Login and it is not working, from this error ERR_TOO_MANY_REDIRECTS Below are the codes. <?php require_once "functions_prototipo.php"; //require_once "navBar.php"; require_once "conexaoBD.php"; if ($_SE...
asked by 06.06.2018 / 15:25
1
answer

MySQL temporary tables

I'm here to study the MySQL temporary tables, and I'm creating some temporary tables. I'm using mysqli , according to the manual , temporary tables delete after the connection is closed. But the truth is that this does not happen to me...
asked by 15.05.2014 / 17:04
1
answer

Pass two variables in the url in javascript

I have a website that has 5 different languages and when choosing a language the text of the page changes! For this I did a function: <script type="text/javascript"> function submitForm() { var thelang = document.getElementById('lang...
asked by 15.06.2018 / 14:14
1
answer

Check that all elements are equal

I'm retrieving all the expired tickets from the database, with the following query SELECT user,status,hash FROM ticket WHERE datepay < date_add(now(), interval -1 month) AND user = '119' The result is as expected, as below....
asked by 17.05.2018 / 19:55
1
answer

Query mysql with join of subquery

I need to create a query that I can filter sales that have issued notes, in my structure there are 2 tables: the sales table and the nfe table. The two are listed by the cod_venda field. How can I do this? SELECT v.cod_venda...
asked by 03.06.2018 / 01:21