Questions tagged as 'mysql'

Tagged questions
3
answers

get the last record of each month

hi I have a question I am trying to filter a query in the following way with mysql: SELECT a, b, d FROM mitabla GROUP BY d; Where d is a column type: datetime , the idea is to bring the last record of each month, if possib...
asked by 29.01.2018 / 19:52
1
answer

Is it normal for php to take so long for the transaction of large volumes of records?

I have a function where I keep mysql with laravel around between 6500 and 7000 records to the database therefore are that amount of iteration is delayed around 15 minutes what I find is a lot, I know that it depends a lot on how this code is...
asked by 22.10.2018 / 14:12
1
answer

How to go through a regristro of a query, and pass the values that are obtained as a parameter to another Store Procedure in Mysql?

I have the following Store Procedure: DELIMITER $$ USE 'open_bd'$$ DROP PROCEDURE IF EXISTS 'LlamarEjemplo'$$ CREATE DEFINER='root'@'localhost' PROCEDURE 'LlamarLibroCompras_ListarMesPeriodo'(IN rutempresaC V...
asked by 21.11.2016 / 22:35
5
answers

Function of 2 variables of different data types how to solve it?

We have the student table with the following fields: doc_est int(30) nom_est varchar(30) ape_est varchar(30) edad_est int(11) They ask us to perform the following function: • Show the name and age of the youngest student. I have...
asked by 20.02.2017 / 20:32
2
answers

Type of data to store ip addresses in mysql? [closed]

Well, that's the best way or the best way to save ip addresses in mysql, both ipv4 and ipv6 addresses Clarifying, what I want to know is in what kind of data to save an IP address, I could keep it from the varchar type considering it as a str...
asked by 14.08.2017 / 20:06
2
answers

In Ruby on Rails how to insert several records at once with ActiveRecord

I want to do this as if I were doing it in mysql INSERT INTO ratings ('id','app_id','user_id','created_at','updated_at','unique','valoracion','valoracions_id') values (1,2,3,"2017-04-07","2017-04-07",12,4.8,1), (1,2,3,"2017-04-0...
asked by 07.04.2017 / 15:18
2
answers

Problem inserting null value in Timestamp on Update CURRENT_TIMESTAMP SQL

When I created the table tb_usuario, I put a field to get the exact date and time when making a record to the table tb_usuario, but when I do an insert, do not take or show the date and time when insert something. this is the code I use...
asked by 27.08.2018 / 18:19
3
answers

Can you pass data from MySQL to PHP and then pass it to another PHP? (or in Js)

I'm trying to make an online store, in my case what I want to do is show the products that are sold (I already have it) but I want the client to see more product information in another window with the images (as do all stores) in my case I s...
asked by 09.12.2017 / 02:18
2
answers

Can you convert Excel tables to a mysql database? [closed]

I would like to know if there is any way to convert Excel tables to MySql. Thanks     
asked by 24.11.2017 / 09:14
1
answer

Count the number of records in a table A by checking a contained value B

I have a question about how to count the number of records in the TUTOR table based on the type of career to which a PROJECT belongs. This is because I want to know how many tutors are in systems projects, agronomy, nursing, in short. It h...
asked by 09.09.2016 / 04:01