Questions tagged as 'mysql'

Tagged questions
1
answer

In what type of java variable do I store a TIME value of Mysql?

I have data of TIME type in my database and I would like to bring these to a variable in java that allows me to do operations (sum of times, compare who is older). I have tried to use variable of type java.sql.Time but it does not get assigne...
asked by 14.03.2018 / 21:57
0
answers

Return null data from a subquery

I am working with MySQL making a list of top 100 keywords associated with scientific articles. The subquery basically provides the top 100 keywords along with the number of times that appear globally . Now, what I want is to filter by countr...
asked by 10.03.2018 / 16:47
1
answer

Double LEFT JOIN to a table does not work when one field is NULL and the other does not

For days I have been thinking about the following question: SELECT U.Usuario AS Nombre, S.Nombre AS Sombrero, A.Nombre AS Arma, Z.Nombre AS Zona, R.Nivel, rangoRollo(R.Honor, R.ID_Usuario) AS Rango FROM Usuarios AS U...
asked by 10.03.2018 / 18:20
0
answers

Join polylines with MySql lowered coordinates on Android?

What happens is that I have coordinates in my MySql database and I want to get them in android to draw a polyline, and I found this tutorial link .... but it happens that I am still a novice, and in that tutorial it only indicates consulting 3...
asked by 25.03.2018 / 20:15
1
answer

Basic query of Database

My query is about how to do an update to update several columns at the same time, work with java and mysql. stat.executeUpdate("Update producto set Prod_nombre= '"+Nom+"' , Prod_precio="+pre+" , Prod_existencia="+exis+" , Prove_id= " +prove...
asked by 08.03.2018 / 04:05
0
answers

Excel report php mysql

Good morning, I have the following program that makes me look up a mysql table and also generates a report in excel: The problem is that when I want to make a report, it does it but in addition to the report table, it adds more things ....
asked by 25.03.2018 / 20:07
1
answer

Save date in MySQL in c #

I'm doing an ABC project in Windows Forms through visual studio, and after several forms I need to save the date, however, at the time of saving the connection is not successful (the connection works well with other forms that do not require the...
asked by 11.03.2018 / 02:58
0
answers

How can I solve this problem? error # 1235

This error appears when I try to insert into two tables at the same time using the t3 detonator. Here's the code: drop trigger if exists Actualizador; delimiter go CREATE TRIGGER Actualizador AFTER INSERT ON banca FOR EAC...
asked by 05.03.2018 / 20:52
1
answer

sum of columns mysql php

Hello, how are you! I need your help, I'm doing this, but the answer is very difficult to find on the internet, I've been looking for a solution for hours, I'm sorry if my question is basic, PROBLEM: I need to add all the example sales:...
asked by 06.03.2018 / 01:29
0
answers

PHP does not run on the server

I'm trying to make a project HTML with PHP and while I was developing it locally it was great, once I uploaded it to the server I had several problems, for example: I have a page "index-mercadeo.php" that performs a query...
asked by 06.03.2018 / 02:13