Questions tagged as 'sql'

Tagged questions
1
answer

"Simplified" search of the same value in different fields (in the same table)

Currently for what I mention I use something similar to this: SELECT * FROM 'tabla1' WHERE 'c2' LIKE 'leonidas' OR 'c1' LIKE 'leonidas' OR 'c0' LIKE 'leonidas' What I am interested in knowing is, if I can do some sort of grouping of all th...
asked by 23.08.2018 / 18:14
0
answers

Error making an SQL query with JavaScript

I'm trying to do a SELECT from node.js to get an error from a table of "errors" but I get the following error and I do not know what else to do or what is due.    UnhandledPromiseRejectionWarning: RequestError: Could not find stored   procedu...
asked by 02.10.2018 / 00:43
1
answer

Update field of a table with the value that same field has in another table

I have a table of items to sell ( ARTICULOS_TBL ) that I sort in a field of that table by family (field CODFAM ). That is to say, it is the case that there are a large number of articles that belong to the same family. In total there...
asked by 02.10.2018 / 13:21
0
answers

help Warning: PDOStatement :: execute (): SQLSTATE [HY093]: Invalid parameter number

<?php class Insertar{ public $mensaje; public $nombre; public $email; public $password; public $genero; public function insert() { $model = new Conexion(); $conexion = $model->conectar();...
asked by 17.08.2018 / 23:31
1
answer

Problems to perform a massive load on mysql

It turns out that I have created the following table: cabtm char (3) not null, cabdoc char(8) not null, cabdat date, cabven char (3) not null, cabcli char (12) not null, primary key (cabtm,cabdoc), index cabecera_fkindex1(cabven), foreign key(...
asked by 16.08.2018 / 21:17
1
answer

How to list records with subrecords in mysql and php

What I want to do is the following, I have the following tables in the mysql database manager Tabla - comentarios id_foro int (11) id_comentarios int(11) id_user_comment int(11) file_comment text date_comment Tabla - respuestas_comentarios...
asked by 30.07.2018 / 16:35
1
answer

MySQL table creation methodology for repeated values

I want to ask you about what is most effective in a particular case. For example, I have these tables: The turn values would be "TOMORROW, EVENING AND NIGHT" my question goes in this sense, it is necessary to create a separate table (as...
asked by 04.08.2018 / 04:58
1
answer

Concat of two fields in different rows - ORACLE

I have the table Adjudicacion which carries various data, including no_garantia , and each row of the query would be an adjudication. Each award, as I said before, has its kind of guarantee (normal, professional or both). If the awa...
asked by 09.08.2018 / 15:00
0
answers

SQL instances of a remote server

The problem is the following, I would like to obtain a list of all the sql instances of a remote server, currently I have only been able to get the list locally using the following code fragment provided by Microsoft. class Program { stati...
asked by 11.09.2018 / 10:17
0
answers

Problem with group by in mysql and slowness in the query

I have the following situation with a MYSQL query. What happens to me is that I have two tables, that I'm joining by LEFT JOIN to bring all the records that are in the first table that is table3 . In the second table pay_amb where the...
asked by 10.09.2018 / 17:10