Questions tagged as 'mysql'

Tagged questions
0
answers

I need to search the database depending on the selected checkboxes of the regions, their states as it could be solved

table = commerc fields id, name, brand, region, district, provincia, categoria I need that when consulting the regions, I bring the records and can select through a checkbox the districts and provinces of the selected regions....
asked by 24.10.2018 / 13:16
1
answer

How to delete old records according to the date

I am working with tables in mysql and I am not able to delete the oldest records with respect to the dates, there are several users who have several records but I just want to leave the most recent records of each user select min(upda...
asked by 18.10.2018 / 12:40
0
answers

SQL query in MYSQL that I grouped the data by time segment

I am trying to do an SQL query where I group the result in time segments, that is, calculate the average of a data every 5 min, my query for now goes like this: SELECT DATE AS DATE, method AS METHOD, red AS red, state AS STATE FROM table WHERE...
asked by 19.10.2018 / 14:13
1
answer

how to bring the records and group the repeated and also show?

this is my BD on phpmyadmin commercer_id | commerce_district| 1 abacay 2 abacay 3 ahuac 4 alto de la alianza 5 alto de la alianza 6 amarilis This is my query, but...
asked by 19.10.2018 / 14:04
1
answer

I want to bring two records of my ID and DISTRICT fields but the districts are duplicated I want to bring only one of them as I do?

try{ require_once('conexion.php'); $sql = "SELECT DISTINCT(TRIM(commerce_district)) AS commerce_district, commerce_id FROM 'commerc' ORDER BY 'commerc'.'commerce_district' ASC "; // $sql...
asked by 19.10.2018 / 12:59
0
answers

Problem when running a stored procedure does not execute the change in c # mysql, mysql and workbench

Codigo ConexionBd.ConnectionString = ConecionMySql.CadenaBaseDatos(); Comando = new MySqlCommand("DeleteUser", ConexionBd); Comando.CommandType = CommandType.StoredProcedure; Comando.Parameters.AddWithValue...
asked by 23.10.2018 / 02:42
1
answer

Use indexes in the WHERE of the UPDATE and DELETE

How optimal is it to create an index for the fields used in the WHERE of the UPDATE and DELETE statements? I have researched on the subject and in general I find split opinions, in general the penalty is mentioned for all the sentences that are...
asked by 15.10.2018 / 23:21
0
answers

Import data into MySQL with mysqlimport

I'm trying to import data with the mysqlimport tool and it gives me the following error:    mysqlimport: Error: 1290, The MySQL server is running with the   --secure-file-priv option so it can not execute this statement, when using table: Cit...
asked by 17.10.2018 / 12:39
1
answer

Optimize java code and mysql connections

I have developed a desktop application in Java and I use connections to MySQL , at the moment it is locally, but I have noticed that it uses my processor too much, reviewing the open processes of MySQL , I could find that it leaves many proces...
asked by 16.10.2018 / 05:29
0
answers

Problem with Worksheet.php PHPEXCEL

I have been using this tool to generate excel files, and it has worked excellently, but when creating a new excel it marks me an error and I can not find a solution, I leave here my code and the code of the Worksheet. ------------ Code that I...
asked by 15.10.2018 / 17:23