Questions tagged as 'sql'

Tagged questions
2
answers

How can you get data from a table 1 that is not in table2?

As I can do to obtain the data from a table1 that is not in another table2 and that is different from an id (idmodselection) that is in table2, I am working on 2 tables that are related, which are: Tabla 1: requisitos idrequisito int (Clave pr...
asked by 18.09.2018 / 16:12
1
answer

Problems With INNER JOIN PUT A CASE WHEN when you are a CONCAT

I can not round off, what I need is that I have a left join of which the ON is two concat LEFT JOIN BD_MigracionQV.dbo.TBL_QV_Hecho_Produccion_IF Produccion ON CONCAT(Cita.IdPaciente, Cita.IdMedico, convert(char(10), C...
asked by 24.09.2018 / 15:46
1
answer

Search all the articles of a SQL query [closed]

Hello everyone I have the following query in SQL SELECT "mrp_bom"."name" AS "NAME", "mrp_bom"."code" AS "REFERENCE" , "product_product"."name_template" AS "PRODUCT" , "mrp_bom"."product_qty" AS "PRODUCT QTY" , "product_uom"."name" AS "PRODUCT...
asked by 09.11.2017 / 19:51
0
answers

doubt good practice when uploading odf files with php

I have several questions, what happens is that I want to save the path of a pdf file in a database. Question should the files be saved in a folder where the project is ?, when uploading the page to a server the route does not change?, Is a good...
asked by 02.01.2019 / 14:27
1
answer

because my code duplicates mysql records?

I have a problem when I make this query in mysql select count(carne) TOTAL_ESTUDIANTES, profesor.nombre PROFESOR, cursos.asignatura CURSO from profesor, cursos, matricula; I only have 4 students but when I do the consultation, everything is...
asked by 03.05.2018 / 20:33
1
answer

Query with two types of INT and VARCHAR data

I have two tables from which I select a field of each for the query and fill in the datagrid only that gives me error because the id is in int type and the other is a string of type varchar in which it has several ids registered....
asked by 04.05.2018 / 18:16
1
answer

how to visualize a subquery while viewing the web without apliacr submit [closed]

I explain if when creating this website, I select a table: Table sr_productos id nombre_esp 1 NombreA 2 NombreB 3 NombreC 4 NombreD the id 1 who in the textarea part marks the result of immediate in the variable: $id_producto2 T...
asked by 16.01.2017 / 01:32
2
answers

Help with this query please, I do not know how to do it [closed]

these are the data of my table Tabla envios ID proveedor, id componente, idarticulo, cantidad, fecha (1,'C1',100,100,'01/04/2013'), (2,'C2',200,200,'03/11/2013'), (3,'C3',300,300,'05/07/2013'), (4,'C4',400,400,'21/09/2013'),...
asked by 05.12.2018 / 14:38
2
answers

How to save an array of bytes [] in SQL?

Is that I have a serialized image in an array of Bytes in C # - UWP, here the post: How to serialize an image (bitmap) in bytes [] C # UWP? but now I have to save it in a Data Database in SQL and I do not know what field to use for that....
asked by 09.11.2018 / 20:30
1
answer

NullPointerException in JSP using SQL

I try to make a very simple web application, where it shows the result of the execution of an SQL query. But it results in an NPE. Here is the JSP: <%-- Document : consultas Created on : 25-may-2017, 23:20:40 Author...
asked by 26.05.2017 / 06:27