Questions tagged as 'mysql'

Tagged questions
1
answer

How to add data from html table to textbox or textarea

Dear, I have a question, I would like to know how I can add data captured from an html table with javascript or jsp. My idea is that every time I select a row of a table with a checkbox, I add the value of that data in a textbox or textarea, and...
asked by 03.08.2018 / 21:11
2
answers

I have a MySQL query dated and when I execute it, it does not return any error or return any value to me

I have the following statement in mysql select detalle_v.idp, producto.nombre, count(detalle_v.idp) as cantidad, detalle_v.precio as p_unitario, sum(detalle_v.precio) as total from detalle_v inner join producto on detalle_v.idp = producto.idp...
asked by 25.07.2018 / 05:27
1
answer

ERROR CONNECTING TO BD PHP 7

I'm trying to generate a JSON file, but I'm getting ERROR 2, when I try to connect to the BD, my hosting uses PHP7, I do not know if that is influencing the error, before it worked correctly. ERROR:    Opps some thing went ERROR 2 PHP...
asked by 25.07.2018 / 07:14
2
answers

Compare 2 columns of 2 different tables in the Database

I'm trying to compare 2 columns (difficulty, difficulty_student) of 2 different tables (EXERCISES, ANSWERS) from the Mysql database and create a new column in the table ANSWERS comparing both tables with a VARCHAR data type (YES or NO...
asked by 15.08.2018 / 11:11
1
answer

How to update records in a database after making the query?

I am doing the data update of a record in my database but before I need to obtain the data of that record in its fields respective this is my database. Field type key default servicio_No int(11) PRI NULL ti...
asked by 16.07.2018 / 17:53
1
answer

Limit number of records and sort them

I have two tables one of clients and one of sales where I must select the 30 LATEST records added to the sales table, show the information of the clients that made those transactions and order them upwards with respect to the id of sales...
asked by 18.07.2018 / 01:32
1
answer

Sort values of the columns from largest to smallest in an array and save each ordered value in a new variable

The data in the blue box exists, the data in the red box must be registered, It is to order the (data from the blue box) from largest to smallest and pass them to the column of the red box, according to their order. What I have done...
asked by 30.07.2018 / 23:13
1
answer

Do not save the data in the database

The database 5 tables: client, room, history, staff and user. In the user table is the ID which also happens for the room as user_id, I make my normal form and it appears that the room has been created, but it does not show it or save it, fro...
asked by 31.07.2018 / 02:13
2
answers

Problem with mysql connection in java

I have this code to connect to a bd but the problem is that it does not enter the while loop public static void conf(){ System.out.println("Ingrese serial"); String numSerial = sc.nextLine(); try{ Class.forName("com.mysql.j...
asked by 20.07.2016 / 13:46
1
answer

group result of statement mysql-workbench

I have this sentence. select nombrem,idparcial,calificacion from calificacion inner join parcial on parcial.idparcial=calificacion.fkparcial inner join materia on materia.idmateria=calificacion.fkmateria; and it gives me this result. nomb...
asked by 31.07.2018 / 03:45