Questions tagged as 'mysql'

Tagged questions
1
answer

Load MySQLl data in Modal Bootstrap

Hello, how could I load all the data of the person in a modal window when clicking on the button that is shown in the image called Register? I need to click on it to load all the data, which is in a database in MySQL. I know th...
asked by 22.02.2017 / 15:08
3
answers

Get fields that contain a phrase with Match () Against ()

I'm trying to get the books whose titles contain what the user enters. Assuming I have the following books: Trees Planes There was once trus Assuming that the user entered the letter a , before resolving it using the followin...
asked by 24.02.2017 / 04:44
2
answers

Restart Mysql before the maximum connections arrive

I have a MySQL DB running on a Debian machine in GCP, which sometimes reaches the limit of connections, which leaves the application stopped until it is restarted and then the application can be reconnected. Currently has a maximum number of...
asked by 12.12.2018 / 15:44
2
answers

Improve MySql query coding

I have the following a doubt regarding the code that I implemented. Although it is functional, I am not convinced by the way in which I managed to solve the problem. What it does is calculate the average of the recorded data at the exact time...
asked by 06.12.2018 / 15:26
1
answer

Error in mysqli_stmt :: fetch_assoc ()

I am trying to develop a function that will help me simplify my database queries. I am implementing it with prepared queries and a bit of dynamism at the moment of knowing that I am executing. Actually I have never used the prepared queries nor...
asked by 14.10.2018 / 07:14
2
answers

Problem when displaying modal data from BD in Laravel

I have a table that brings all the records of my complex table and a button that opens a modal, the problem is that when selecting a record of the table (In the view) it does not show me as it corresponds the information of the chosen registry...
asked by 14.12.2018 / 15:14
1
answer

Multiply 2 MySQL columns with decimals

I have a column named PRECIO and another CANTIDAD , column PRECIO is in text format and the decimal separator has a comma, (this is the result of an excel export to mysql). Achieve multiply PRECIO x CANTIDAD...
asked by 21.08.2017 / 15:36
2
answers

Is there a way to adapt an SQL statement when a null field arrives?

Hi, I hope you're ok, is there any way to adapt an SQL statement so that it reacts according to whether a parameter arrives nil or not, something like this: drop table if exists tabla; create table tabla ( id int primary key AUTO_INCREMENT...
asked by 21.08.2018 / 18:07
1
answer

Save date in unix format in Mysql

I need to store records with field in date and time in Unix format by default in a mysql table, is it possible to do that? Can you create a table with this field by default?     
asked by 01.09.2018 / 02:52
3
answers

Call data without values in MySQL

At the moment I have a query in MySQL that adds the consumption that a certain person did in a time range: SELECT e.codigo, round(sum(c.valor),2) as cupo FROM tbl_consumo c INNER JOIN tbl_empleado e on c.tbl_empleado_id=e.id WHERE fecha...
asked by 18.12.2018 / 21:50