Questions tagged as 'mysql'

Tagged questions
1
answer

MYSQL query with range of Dates of an id

I'm doing a query on mysql, which should make me based on a given id and a range of dates, bring me the records between those dates. I'm starting to learn mysql so the most sure thing is that I'm formulating everything wrong. This is being im...
asked by 08.10.2018 / 17:23
1
answer

Group results in MYSQL applying inner join

I'm trying to group 3 related tables this would be the sql code SELECT * FROM metadata_values mvalues INNER JOIN metadata_descriptors mdes ON mdes.idDescriptor = mvalues.idDescriptor INNER JOIN metadata_schemas mschema ON mschema.idSchema = md...
asked by 21.08.2018 / 22:14
1
answer

Migraciones assign value by Default

I am working on a project with C #, Entity Framework and MySQL.  I wanted to know if you could help me with a "problem" I'm having with migrations. I was working with MySQL version 5.6 and go to version 5.7, the problem (if you can say problem)...
asked by 18.04.2018 / 17:55
1
answer

Error related to sql_mode = only_full_group_by when running MySQL query

I'm trying to do an ORDER BY, I have a query which shows me some products and the query works for me when my system is running, but I added an ORDER BY and the query shows me the following error, huh searched on the internet, but it is not entir...
asked by 24.04.2018 / 00:09
1
answer

Return true or false PHP

I realized that the validation did not work and that no matter what data you enter from the maintainer, this code always returns 1. What I'm looking for is that it returns 0 if the sql query did not return any results. if (!$cnn) { die("Co...
asked by 27.11.2018 / 16:51
1
answer

Angular filter to pass HTML string

Hi, how can I do a angular filter, to read a string html , or how do I create a method to read a string html <div ng-bind-html="item.description"></div> why when I save text with he saves it but he show...
asked by 27.03.2018 / 18:57
2
answers

SUM with inner join mysql

I want to show information on each provider to make a sum of how much income he had on a given date. Mi tabla entrada ----------------------- cajas peso idproveedor ----------------------- 100 1000 1 100 2000 1 Tabla proveed...
asked by 05.05.2018 / 01:30
1
answer

Ask for data with prompt () and store it in mysql with php

I am working a sales system but when a product has a unique serial number I need you to show me a prompt () to write the serial number and then store it in a php variable and store it in mysql. This is my code: <?php if($tProducto == "...
asked by 25.03.2018 / 11:40
1
answer

How to show different messages when entering duplicate data to the database? Php / MySql

Hello! I am trying that, when the user enters the name of a region, if the same one is repeated it will be shown in the screen "An error occurred", but I can not. Region.php: class Region { private $regID; private $regNombre;...
asked by 24.03.2018 / 20:02
1
answer

Help with data type in MySQL

This is the database script, everything is inserted correctly except the part of the precio , when viewing it in a php file (in which all the data is in a table) are presented as: 31.84 38.74 and 32.51 that is, the last number th...
asked by 12.01.2018 / 13:49