Questions tagged as 'sql'

Tagged questions
2
answers

Clause COUNT (1) and DENSE_RANK ()

I have the following query on sql server, the goal is to bring the records of the Personas table that are related to ListaMarketing_persona but since this is an AnyToAny table that joins ListaMarketing , there may be several...
asked by 18.11.2016 / 19:55
1
answer

Error in mysql query with php

$re=mysql_query( "select * from productos where id=".$_GET['id'] ) or die (mysql_error()); This upper line gives me this error, but I can not find it:    You have an error in your SQL syntax;...
asked by 23.03.2017 / 13:31
2
answers

Send form to SQL DB and bring it in table

I am working with WebForms, my form is as follows: <div class="form-group formulario" id="formulariogral"> <form action=""> <div id="titulos"> <h1 class="title" >titulo</h1>...
asked by 26.05.2016 / 18:01
3
answers

How to use the LIKE operator [closed]

I have this sentence in c # to perform a parameterized or filtered search using the like. else if(rbnombre.Checked==true) { try { if (txtbusqueda.Text == "") {...
asked by 05.09.2017 / 20:47
3
answers

how to do a SELECT of two different fields of the same table in a single column in Oracle 11g?

Good morning, I'm making a query I need to make a selection of 2 fields from the same table but within a single column column, that is SELECT desc_equipo, serialnro, serialmac from producto desc_equipo is let's say the field that stores the...
asked by 07.11.2016 / 16:44
1
answer

Update MYSQL does not work correctly

I have this code: <?php session_start(); if (!isset($_SESSION['user'])){ header("Location: index.php");} include("db_files/db.php"); include("inc/functions.php"); $oldpass = mysqli_real_escape_string($db, $_POST['oldpass']); $ol...
asked by 04.11.2016 / 16:35
1
answer

SQL query that adds the STOCK of CodeArticulo equal

I'm running a system on VB.net where I have a datagridview (MultiSelect) with the company's sales record. In another datagridview I show the articles of the selected sale (s) in the first DGV "Select IdVenta, CodigoArticulo, Descripcion, Preci...
asked by 18.05.2016 / 15:53
2
answers

Search and Delete duplicate MYSQL records

Well, my situation is as follows, I have a rather large database, and there are a lot of duplicate records (there are actually many that are repeated more than twice but I do not know how to call that). What I'm looking for is a query to h...
asked by 20.03.2018 / 01:41
2
answers

Enter data from query .sql to table by parts

I have a database dynamically attached to my asp.net mvc project, with 12 columns to fill with test data, since I do not find a software that generates exactly the data I need and the limits of each one as age, names, dates, etc. I think that a...
asked by 10.03.2016 / 19:55
2
answers

Recoverable fatal error: Object of class PDOStatement

Query: static public function contarAccesorios(){ $ejecucion = self::Conexion(); $sql = "SELECT count(idaccesorio) FROM accesorios;"; $registro = $ejecucion->query($sql); return $registro; } Why...
asked by 12.12.2017 / 12:38