Questions tagged as 'mysql'

Tagged questions
1
answer

What do I do so that in a stored procedure I can save in two variables with INTO in front of a query that returns one or several columns?

I explain: It turns out that I have a procedure that establishes two integer parameters, which are then arranged to store each the result of a single value that comes from different columns one for each, the select that I have is some...
asked by 17.08.2018 / 21:11
1
answer

Query: sales per month with condition (MySQL)

I have a problem, maybe something simple, but it still does not work out. This is the result to obtain SELECT month(sale_date) as mes, SUM(subtotal) as Totalizado FROM sales WHERE YEAR(sale_date) = '2018' GROUP BY 1 order by 1...
asked by 26.06.2018 / 21:52
1
answer

Send e-mail taking data from a Database?

Hello friends, I have a problem with only one line of code that no matter how hard I search, I did not find any solution. Use laravel: 5.6 Mysql-MariaDB I have this: And in the part of $message->$usuario->email that is to t...
asked by 22.06.2018 / 02:21
2
answers

Search MySQl field created in the same query

Good morning. I have the following query: select p.id_alumno as id,('estudiante') as tipo, p.url_imagen, concat_ws(' ',p.nombre,p.paterno,p.materno) as nombre, e.nombre as empresa,concat_ws(' ',u.nombre,u.apellidos) as solicitante, p.f...
asked by 30.08.2018 / 20:17
1
answer

Problem with Hibernate

I just had a problem when inserting a product (in this case) in the database. I'm working with the mapping and it always returns "false". I can not find where the possible failure may be. I show the classes. Class Mapping Products: pub...
asked by 04.09.2018 / 10:55
1
answer

How to Perform an Automatic BackUp in MySQL

This script I have advanced but I do not know why it does not work for me, do not place the error if someone can help me? @echo off mysqldump -h localhost -u root -p Dotado256 sixstar_almacen > AlmacenBeta _ 19082018.sql Pause Use...
asked by 19.05.2018 / 22:49
2
answers

mysql delete row "almost" duplicated

The question is this: | id |c1|c2| c3 |c4|fecha 817614 01 30 2517 0 2018-05-18 10:02:43 817615 02 30 2517 0 2018-05-18 10:02:46 817616 03 30 2517 0 2018-05-18 10:54:31 817617 04 30 2517 0 2018-05-18 10:54:39 817618 05 30 2554 0...
asked by 18.05.2018 / 21:58
1
answer

How to add the content of an input to a data in a MySQL table in php?

I have a database on my main computer filled with records of different products, I needed to perform a search and after the product was found through the bar code it would proceed to add an amount entered by a user, the part of the connection to...
asked by 18.05.2018 / 00:08
1
answer

Sort unpaged list in php laravel

I'm organizing some list objects by their names, but I want to sort them without having to page them. The code that I have is the following: if ($filter['sort'] == 'name_asc'){ return Employee::orderBy('first_name', 'ASC')->paginate(100...
asked by 03.10.2018 / 00:56
1
answer

FULLCALENDAR (SHOW SPECIFIC EVENTS)

My problem is that I want to obtain specific events according to a value, and all the information of the events is retrieved from the db successfully from a file with the following code: header('Content-Type: application/json'); $conexion = ne...
asked by 04.10.2018 / 06:11