Questions tagged as 'mysql'

Tagged questions
1
answer

How to save a value in mysql with express

I'm doing a login but I have a problem that I can not save the data in mysql. For the register I made a form with a method post. With express create the connection that is this: const mysql= require("mysql"); module.exports=()=>{ retur...
asked by 17.11.2018 / 15:27
0
answers

Find value first row and first column to make a query

I would need to make a query with two variables when clicking on a link in a cell: Value of the column Value of the first row I have the following table: +--------+----------+----------+ | Name | Open | Close | +--------+----...
asked by 17.11.2018 / 20:01
0
answers

Entity Model Relationship of Minesweeper

I would need a little help with the relational model of the classic minesweeper game, I leave the slogans that modeling should solve:  A ranking of players by number of attempts in the matches until all the mines are discovered.  A ranki...
asked by 18.11.2018 / 12:48
0
answers

insert image path with their respective PHP MySQL data

I am trying to upload a photo with its respective data such as: name, date of creation, among other data, to my MYSQL database but I can only save the image in a server folder, but not insert the image in the bd nor your data, this is my code:...
asked by 18.11.2018 / 09:05
1
answer

Problem with mysql query from java

First I make a record to the database from a Frame and without leaving the application I enter another Frame where I consult the data but the data that I just entered from the previous Frame does not appear, if I close the program and I'll run i...
asked by 25.11.2018 / 06:58
0
answers

Insert data into related tables Mysql Java

My question is this: How to insert data into both a parent and a daughter table. My problem is that in my Java project I have as a parent class a Persona and its two child tables Cliente and Empleado . Class Cliente...
asked by 16.11.2018 / 18:40
2
answers

Help with PHP function to discard a MySQL data

I have the following: $verf = "SELECT nro_transf FROM pedidos WHERE nro_transf = '$nro_transf'"; $result = mysqli_query($db, $verf); $rows = mysqli_num_rows($result); $verf2 = "SELECT nro_transf FROM pagos WHERE nro_transf = '$nro_transf'";...
asked by 16.11.2018 / 15:49
0
answers

MySql: Field @acum: = @acum + count (mtg.idTemaGestion) as accumulated does not accumulate data

I have this query, the problem I have is the following, the field: @acum:= @acum + count(mtg.idTemaGestion) as acumulado is not accumulating the data, it is just showing the count(mtg.idTemaGestion) Try both ways using join (SELECT...
asked by 15.11.2018 / 17:11
0
answers

MYSQL throws me this error: "error getting ddl for object" and tells me that the table does not exist. How can I solve that?

I tell you my problem, I have a server with "Windows Server 2012" where I raise a Mysql service that I manage with "Workbench". Doing development tests I miss the following error: " error getting ddl for object " and " table does not exist "....
asked by 15.11.2018 / 15:48
1
answer

Error running compositeDisposable in an Android fragment

I hope you can help me :) I've been stuck in this and some time. I am running an app that fills Mysql with data and when I try the method in an Activity it works normally, but when I execute it in a fragment it gives me an error when I execute i...
asked by 15.11.2018 / 15:52