Questions tagged as 'mysql'

Tagged questions
1
answer

How to read .sql file with Java

I have a complex query in MySQL with sub-select and joins . I would like to read this script through a .sql file using the JPA / Hibernate language (JPQL or HQL), for example getSession().createQuery(arquivo.sql); ....
asked by 09.08.2018 / 21:39
1
answer

problem checking user already exists in nodejs mysql

I'm not being able to check whether the user already exists dynamically. Basically I want when typing the user name says whether or not I am using nodejs with express and mysql code controller / login const usermameverica = async (connecti...
asked by 10.08.2018 / 11:09
0
answers

Relationship of tables with error 1215

Hello, I'm trying to make a table relationship, it just gives me error ... I have my table tb_conta_fixa and my table users I want to relate the data created from tb_conta_fixa to table users ... I put this quer...
asked by 30.07.2018 / 20:01
1
answer

Select with inner join

Good afternoon, I'm making an app where I need to list all rooms of a user and the last recorded consumption of each room, except that my code searches wrong, if a room has more than one consumption it doubles the same , so I would like some hel...
asked by 30.07.2018 / 19:24
0
answers

How to send data, via POST, from android to PHP in a synchronous way?

I need to send data to the database, and I'm using PHP. I was trying through the Ion library, but because it was asynchronous, the application featured NullPointerExceptions when I had more than one data being sent. I tried to implement okHttp,...
asked by 31.07.2018 / 05:21
2
answers

Replace with variable - mysql

How can I make Replace using a variable? A given variável receives values from a query, so I need to make a Replace in a given column, with the values obtained, how can I do this? follow example in fiddle: link   ...
asked by 27.07.2018 / 03:17
0
answers

how do I save variable values in a mysql database

I'm trying to create a facial recognition system using Opencv to record user access to the school lab but the problem is that I'm not able to save the access time information for each user and neither the image of it at the time that he entered....
asked by 26.07.2018 / 14:01
1
answer

Passing id to another page Ionic 3 (RESTful API with php)

Good afternoon, I'm making an ionic 3 app using the RESTful API with php for MYSQL database connection and my app lists a house with its respective consumption, it follows images of the app currently: > WhenIclickthisViewDetailsbuttonIwould...
asked by 25.07.2018 / 16:32
1
answer

Problem with Trigger After Update with Internal Update in Mysql

I'm creating a trigger in mysql, the trigger is created but when I go to update the flag to test mysql it returns me this error ERROR 1442 (HY000): Can't update table 'aux_Batelada' in stored function/trigger because it is already used by st...
asked by 25.07.2018 / 22:48
0
answers

Integrate firebase database users to the Joomla site to receive notifications whenever a new article is published

Integrate firebase database users into the Joomla site to receive notifications every time a new article is published. I have a site in joomla (www.infobnews.com.br) and created - for him - an android app. Users are registered via APP in the fir...
asked by 26.07.2018 / 00:22