Questions tagged as 'mysql'

Tagged questions
0
answers

SQL CONNECT ERROR: Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root' @ 'localhost'

Good morning I have a problem with the mysql connector, the problem is the following download a library in git here when placing the command node app.js import I get the following error λ node app.js import Failed to load c++ bson...
asked by 01.06.2017 / 13:21
1
answer

Problems with Bootstrap - Modal Window and Nav-Tabs

I have the following problem: Working with Bootstrap, I have a website that shows 12 properties in a thumb, each one with a button to see the details of the same, that button, opens a MODAL window of the property, where I have detailed informati...
asked by 09.06.2017 / 14:37
2
answers

Triggers vs. Stored Procedures

After searching the internet I found several tutorials on the subject, but what is still unclear to me is when to use a trigger and when a stored procedure. Thank you very much for any possible guidance !!! Sincerely, Miguel Angel     
asked by 28.05.2017 / 16:23
0
answers

Update mysql row at expiration date

It is possible to create a function on the server side of the mysql database that automatically updates a row when a date field expires in comparison with the current date.     
asked by 28.05.2017 / 17:58
1
answer

How to hide duplicate data that is displayed in a table in php

** I explain myself better about the image, what I want is that only "one project per ID" is shown, it should be noted that I do not want to use the instructions "DISTINCT, ORDER BY or TOP", because I occupy the fields defects_project_state.stat...
asked by 14.05.2017 / 00:47
1
answer

Problems updating PHP MYSQL data series

Good, I have a modal where they load me the qualifications of a student, if I want to update those qualifications, only I update the last data. Attached modal image Also the code that I have to update on the modal page is: if(!empty($_PO...
asked by 14.05.2017 / 01:40
3
answers

Sort Table Horizontally Mysql

I have the following query: SELECT asunto, MONTH(created_at) as mes, COUNT(turno) as numero FROM tikets where id_sucursal = 1 and subasunto = 'Pago' GROUP BY asunto, mes ORDER BY mes ASC Which throws me the results like this: I wa...
asked by 15.05.2017 / 16:49
3
answers

How to make a trigger that when data is inserted into a table delete a record from that table?

I am doing a trigger in mysql that deletes a record from a table and executes when data is inserted in that table I do it in the following way DELIMITER $$ CREATE TRIGGER 'comp01'.'ELiminar***' AFTER INSERT ON 'comp01'.'<ft_inv_slvta>...
asked by 13.05.2017 / 14:38
1
answer

Image not saved well in BD php

I am migrating to use functions, insert the image but it does not recover it, in the previous normal code it inserts and recovers, it can be said that the image was collected like this: $foto1 = $mysqli->real_escape_string(base64_decode($_R...
asked by 22.05.2017 / 15:23
0
answers

Insert or update values of a checkbox - PHP

Well I want to insert the values true or false according to the checkbox marked to a BD which is the following: CREATE TABLE 'campos_req' ( 'id_req' int(11) NOT NULL AUTO_INCREMENT, 'nombre_campo_req' varchar(120) NOT NULL, 'check_re...
asked by 15.05.2017 / 15:47