Questions tagged as 'mysql'

2
answers

Table lock caused by MysQL trigger

Currently I have a problem apparently with some triggers in one of my tables as it is blocked, by doing a few "INSERTS" the table works correctly but by doing many simultaneous INSERTS (I'm using JMeter for load tests) a DeadLock appear...
asked by 04.04.2018 / 19:02
0
answers

problems updating data with php and mysql

I am working with the loadata but mysql if you accept the "" but not php, so I decided to insert all the raw data (with loadata but using only varchar fields) in a table for later on those fields to do operations, my problem it is in the last co...
asked by 05.04.2018 / 03:17
0
answers

Send data from a form on the same page

I wonder if it is possible to send data from a form on the same page with all the code. Separately it works perfectly for me, but what I need is for the data to be sent in the same file and refreshed. I leave my code here. <?php //...
asked by 07.04.2018 / 00:42
0
answers

yii problems with my dependent menu

I have problems to make a menu dependent, the problem I have is that it only takes the data from one menu and the other takes all the values by default. This is the function of my controller: public function actionAjaxResultados(){...
asked by 02.04.2018 / 14:24
0
answers

Help registration of footprint in Vb

I have a problem: when I tried to create the button to find the fingerprint that I have registered in the database, nothing works for me anymore, I only get the message of "No se pudo inicializar la captura" , but now I do not know where I...
asked by 03.04.2018 / 00:49
0
answers

How to fill the JFrame fields stored in MySQL using Hibernate?

my question is how can I fill in the fields of my JFrame with the data stored in my bbdd using hibernate? That is, I select a row of my JTable , I get its id and by clicking on a edit button there will be a form that will have a...
asked by 14.12.2018 / 15:23
0
answers

Insert default values MySql after 1 minute

I need to know how to automatically insert a row with default values with a time condition (the script should evaluate if there is not a data entry from 1 minute and then insert the default row), how can I automate the script to to evaluate the...
asked by 03.06.2018 / 23:37
1
answer

Update a div ajax

I want to get to do a div recharge only when it finds a modification in the database I currently have this so, if you can help me I would appreciate it is for a shift system that I am doing: <?php require_once("../../db/db.php");...
asked by 02.05.2018 / 18:40
1
answer

Send error message when entering incorrect data in login with php

I'm new to this php. I successfully made a login in php, I can enter my data and validate it to see if the correct data is in the database. But when I enter some incorrect information, all it does is send me back to the login page (login.p...
asked by 02.05.2018 / 02:04
2
answers

# 1054 - The column 'parte.codigo_componente' in where clause is unknown

I have the following problem. I am executing this sentence: select descripcion FROM componente where componente.codigo = pieza.codigo_componente AND pieza.codigo = pieza_equipo.codigo_pieza AND pieza_equipo.codigo_equipo = equipos.codigo A...
asked by 13.04.2018 / 00:45