Questions tagged as 'sql'

Tagged questions
1
answer

Problem with the bridge table in SQLite database

I am learning SQL, using SQLite. I'm seeing how many-to-many relationships work between tables that use primary key and foreign key. I have three tables: contacts , which has the following columns: contact_id (primary key), first_nam...
asked by 18.10.2018 / 08:44
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 / 15:16
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 / 15:16
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 / 16: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 / 16:04
1
answer

sending parameters from asp.net mvc to sql server

I need to send these parameters to Sql Server to be used in my stored procedure: (int[] DedudccionesId, DateTime FechaDesde, DateTime FechaHasta) //POST: Detalle Planilla Empleado [HttpPost] [ValidateAntiForgeryToken]...
asked by 23.10.2018 / 05:38
0
answers

I have a problem in php

To be honest I have not studied crud, I made the create easily but I have a problem to make an edit. I did a get to receive a value auto increment (id) to load the fields that have that id, the problem is that when I give submit the variable id...
asked by 23.10.2018 / 05:13
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 16.10.2018 / 01:21
1
answer

When I make a query within a function to assign the result to a variable, if the query does not return anything, does it save a null value?

SELECT c.horas_aportadas INTO horas_aportadas_coordinador FROM voluntario c WHERE new.id_coordinador = c.nro_voluntario; In that code, the id_coordinador is an attribute that can be null, so if it is then the query does not return anyth...
asked by 20.10.2018 / 19:11
0
answers

It does not show the sql query with some

I have this code in php to show the entered data, it just shows some not all, what is event_id , event_description and value which are the fields in the BD shows them correctly, but data such as title_event does not show them. <?php...
asked by 10.10.2018 / 23:07