Questions tagged as 'mysql'

Tagged questions
1
answer

Query to add does not give me the result

I'm trying to add the amounts of a column, I have this query, but when I show it on the Web it does not show me the result. <td> <?php $query = mysqli_query ("SELECT SUM(importe_total) FROM consumobar"); $result = mysq...
asked by 30.10.2017 / 17:00
1
answer

Error in MySQL Procedure

I am trying to perform the following stored procedure CREATE PROCEDURE insert_trabajador ( IN rut VARCHAR(12), IN nom VARCHAR(50), IN est VARCHAR(50), IN sueldo INT(11) ) BEGIN INSERT INTO trabajadores ( rut, nombre, estado, sueldo_base ) VAL...
asked by 08.11.2017 / 20:57
1
answer

Error with group by in mysql 5.7

I have the following query : SELECT count(id_estadistica) AS num_clicks, a.*, b.* FROM estadisticas AS a LEFT JOIN noticias AS b ON a.id_elemento = b.id_noticia WHERE b.id_noticia IS NOT NULL AND b.fecha_pub BETWEEN '2017-10-01 00:00:01...
asked by 08.11.2017 / 07:16
1
answer

Triggers PhpMyAdmin

I have the following trigger: CREATE OR REPLACE TRIGGER tr_insercion_evento AFTER INSERT ON evento BEGIN INSERT INTO historico_evento(historico_evento.id, historico_evento.fecha_cambio, historico_evento.evento_id, historico_evento.usuario_exo...
asked by 08.11.2017 / 14:55
1
answer

How to extract a String number from a DataGridView C #

What I want is to take the numerical value of a string for example IMP_5, take only 5 that would be in the last row of a DataGridView. The last row of records of all you have. Someone can help me.     
asked by 13.11.2017 / 02:58
1
answer

How to keep selected a nested combobox data when reloading the page?

Hello everyone, I would like to know if it is possible to keep a data of a nested combobox selected and that at the same time this data that is selected to send the other data automatically, it is necessary to say that I already have the nested...
asked by 26.10.2017 / 22:06
1
answer

Relationship Identifying Vs No-Identifying

First of all, I told you that I have already read several similar questions with "technical" answers that look like C & P. What I need is a clear example. The normalization is 3NF. In this project, in the administrative panel, you have to...
asked by 22.10.2017 / 15:12
1
answer

Error filtering SQL query

It is assumed that this query has to filter for all the conditions that are after the where or combine the conditions but, when I put a date range, a name and an interaction title, the data does not they filter as they should. SELECT DI...
asked by 25.10.2017 / 01:06
1
answer

Change Oracle port 11g

I would like to know how to change the port of oracle 11g and what to occupy, that is, to know one that is free, since port 8080 is occupied by sql server and the 8081 Mysql. Greetings and thanks.     
asked by 20.10.2017 / 04:30
1
answer

Increased auto field with stored procedure repeats

I have a problem with my system since I generate a self-incremented code in Mysql which works well when the system is used by only one user when using it 2 or 3 users this code that I generate automatically is repeated 3 times since its first cr...
asked by 20.10.2017 / 09:49