Questions tagged as 'mysql'

2
answers

error can not be converted String to JSONObject android studio when trying to update

PHP PDO Code <?php require('conexion.php'); $Code=$_GET['Code']; // Consulta de Usuarios en la base de datos $consulta = "SELECT Code, User, Pass, Tip...
asked by 12.05.2017 / 20:42
1
answer

Bring data according to the ID of an option or a button of a list

Good community, Beforehand, Thank you for taking your time to read, my query is as follows: I have a table that contains some data: [] And a button to load a modal window: But it is possible to bring the data according to the I...
asked by 20.05.2017 / 18:23
0
answers

Visual Studio Connection 2015 with MySQL 5.6

I have a problem and that is that I need to make a web application using sharp c and the IDE Professional Visual Studio 2015 linked to the bd MySQL engine, for which install this version that includes the connector.net (6.9.9), workbeanch and my...
asked by 12.05.2017 / 03:39
1
answer

Data management arrays, maps - CVS

I have several questions about how to handle a record module in my application, since the requirement indicates that a CVS file should be loaded with approximately 18mil to 20mil records . The file must be loaded in a JSF application, with...
asked by 05.06.2017 / 05:11
1
answer

Implementation log_changes Mysql ... How do I save the User that I update, insert or delete the record? [closed]

I commented that I am making a log of changes on a table in mysql, I have the trigger that runs every time I update, insert or delete and I also have the table where I save the changes, the sentence with which I save the user which made the chan...
asked by 20.04.2017 / 21:16
0
answers

error The user specified as to define ('root' @ '%') does not exist

I'm calling a procedure from a page, every time I call it I get this error in console 09:34:08,942 INFO [stdout] (http-localhost/127.0.0.1:8080-3) 20/04/2017 09:34:08.941 INFO projectX:ReportRankingPointsMB:searchReport:86 - [UserId: 210] s...
asked by 20.04.2017 / 17:37
4
answers

Why does the Inspector Character ( ) appear in some data obtained from the Database?

I was dealing with the dilemma of converting the accents and special characters of my system. It happens that now some of the data obtained from the database that have tildes come out with this: . The strange thing is that there can be up...
asked by 31.03.2017 / 14:53
0
answers

Fill a dropdown of JSN Uniform

I am creating a form with JSN Uniform in which I have a dropdown that must be filled with values from a database, I have dealt with several videos but I have not achieved results. How can I fill my dropdown of JSN umiform with data from...
asked by 18.04.2017 / 20:47
3
answers

Join error of two tables. By doing a group by and ordering order by timestamp date

I need to know why you answer me as I need a query, I have a table of medical data and another of patients where two strings called id are not referenced or anything. my medicals table. +--------------------------------------+---------+----...
asked by 05.04.2017 / 23:24
3
answers

Short SQL query

In an application, if the user inserts a value in a input , the variable named $nro_entrada_registro will take that value and in addition a current date will automatically be inserted in a field called fecha_registro . But whe...
asked by 11.04.2017 / 22:46