Questions tagged as 'mysql'

Tagged questions
1
answer

How to prevent a listView from returning to the beginning when updating its adapter?

My problem is as follows. I have a ListView that is completed from data obtained in a mysql query by means of volley. This task is performed once per second by means of a timerTask. The ListView returns to the first item once per second (each ti...
asked by 20.03.2018 / 20:27
1
answer

Configure Spring Boot with two DataSources

I am using Spring Boot 2.X with Hibernate 5.X to connect two MySQL databases (Bar and Foo). I want to be able to list the different entities, with all their attributes (ID, Name and relationships @OneToMany/@ManyToOne ), of each of the...
asked by 07.03.2018 / 17:31
3
answers

Advanced search and mysql query

Good morning, I have a problem when it comes to making a query, since it does not return the desired result. The conditions for the consultations are marked by the user with a form similar to this one: And this is the scheme of the tabl...
asked by 17.05.2017 / 11:42
1
answer

List nearby points sorted by distance in Mysql Spatial

I have georeferenced points of interest in a table CREATE TABLE 'poi' ( 'poiID' INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, 'name' VARCHAR(50) NULL DEFAULT NULL, 'location' POINT NOT NULL, PRIMARY KEY ('poiID'), SPATIAL INDEX...
asked by 01.12.2017 / 20:05
3
answers

mysql: fields and count (*) of union

Following the query I made a few days ago ( mysql pivoting table result of fields json ) I have found another problem. It turns out that I have to obtain several fields of union and divide it by the total number of elements that the union has....
asked by 29.12.2016 / 11:40
1
answer

mysqli-affected_rows does not work with stored procedure

I have a piece of code that inserts a record in the persona (id_persona, apellidos, nombres) table, I'm using MySQLi and PHP5 and I have the following: $query="CALL persona('".$nombres."','".$apellidos."')"; $mysqli->query($query); $...
asked by 28.12.2015 / 06:22
2
answers

java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

I have had a problem when returning a value of BD mysql null in '0000-00-00' format The error that occurs is:    exception       javax.servlet.ServletException: java.sql.SQLException: Value '0000-00-00'> can not be...
asked by 31.03.2017 / 23:05
1
answer

modify jlabel according to user logged in java

I need to modify a Jlabel of the main page according to the user that has logged in in the Login Frame. I leave the code that I am working on, in case you can help me. I remain attentive to your answers void generarNombre() { String...
asked by 21.08.2018 / 20:08
1
answer

Perform SQL query from Javascript

Good morning, I understand that you can not perform an SQL query from Javascript, but I do not know if the information I have found through Google may be obsolete or not. The fact is that I have some elements that when pressed, a small script...
asked by 25.03.2017 / 11:18
1
answer

# 1064 MySQL Error

I'm trying to import a .sql file into HeidiSQL. When I try to execute the file to fill in a table already created, I am disabled by the following error:    SQL Error (1064): You have an error in your SQL syntax; check the   manual that corres...
asked by 27.12.2018 / 11:15