Questions tagged as 'mysql'

Tagged questions
0
answers

Node JS + MySQL

I took as skeleton the code generated by Express JS and everything works fine. The issue is that when I show my page ... / one, it shows me the right result but only for about 5 ms and the content disappears. Do you know why this happens? I woul...
asked by 22.03.2018 / 20:14
1
answer

Help my transaction in php pdo is sometimes done and sometimes not

I am carrying out a transaction, what I do first is a post of values obtained from a form of both arrays and variables, sometimes the values are inserted correctly in the table orders and detail, in other occasions this does not occur. <?ph...
asked by 01.11.2017 / 19:50
0
answers

wpdb makes queries in incorrect order [closed]

I have a problem with processing a file. First I give you a summary of the situation. The idea is to receive in a csv the prices of 3 types of rooms for a specific date (one line for each day), and with that file I must insert them in the cor...
asked by 07.11.2017 / 09:05
1
answer

MySQL trigger Calculate previous reading difference with current reading

I have a table that is of meter readings, the fields are: id_lecturas int(10) unsigned NOT NULL fk_contadores int(10) unsigned NULL fecha_lecturas datetime NULL valor_lecturas decimal(10,3) NULL diferencia_lecturas decimal(10,3) NULL When a...
asked by 05.11.2017 / 13:19
0
answers

Report with Itextsharp

Dear, I need your help, I am developing an asp.net webform, c #, MySQL and itextsharp report and I need this report to have a certain format. I retrieve the information through the database and keep it in a datatable , until there is every...
asked by 19.10.2017 / 20:00
3
answers

MySQL Consult several data of the same field

Hello I hope to explain my problem well, first apologies if my question is not understood, from a table log of events I need to obtain data of those events, I have the fields DATE, ID, DATA the field DATE is of DATETIME type, the field ID repres...
asked by 21.11.2017 / 00:00
1
answer

Query about time range in SQL Server? [closed]

Good day, I have to make a query about the generation of alarms, I want to know how many seconds it remains active (Column: EventTime) every period of power on and off (Column: Message), of the time that passes in that time I want to gener...
asked by 10.10.2017 / 22:37
1
answer

How to save in bd, the coordinates that I am showing in a div.innerHTML?

Good, I'm new to the community. My problem is the following, I need to save the coordinates (latitude and longitude) in my database when the person makes a record in my Web Application . Before making the new entry the user agrees to share thei...
asked by 12.10.2017 / 22:35
1
answer

Bring all the data of a table in mysql

I have the following query: SELECT pr_production_units_details.id AS idProductionUnit, pr_production_units_details.production_units_detail AS productionUnit, pr_varieties.variety FROM (SELECT MAX(sw_sowing.id) AS id FROM sw_sowin...
asked by 17.10.2017 / 22:59
1
answer

how to transform method into c # a method async c #?

how to transform the method to asynchronous so that this action is executed in the background. public void cargar_datos() { MySqlCommand cmd = new MySqlCommand("select id_zona, descripcion_zona from tb_zonas", conexion.ob...
asked by 02.10.2017 / 21:28