Questions tagged as 'sql'

Tagged questions
1
answer

Problem inserting data with MySQLi

I have this database created in phpMyAdmin: The problem I have is that when I insert the data of the form where I create a user manages to connect to the database, the data sends them but does not save them, concluding with the redirect...
asked by 26.12.2015 / 07:20
2
answers

Get the maximum amount for each record in sql query

I work in sql server 2000 and I'm doing a query to a "people" table, that has many duplicate records, does not have a primary key, that is, each time a person enters the system they have a record with a different age (the one that was recorded a...
asked by 09.06.2016 / 20:02
1
answer

Modify user

I have a database with 2 tables. A call sec_users with the following fields: pk_user login pswd Another table called solicitud with the following fields: pk_solicitud fk_usuario fe...
asked by 02.04.2018 / 11:10
3
answers

sql query to delete from two tables at a time, SQL Server

I have two related tables, Ad_TypeConsulta and Ad_consulta, a type of query has several queries, I look for the sql script to eliminate both the type and the queries that belong to that type. DELETE Ad_TipoConsulta, Ad_Consultas FROM Ad_TipoCo...
asked by 28.04.2016 / 22:13
1
answer

SQLServerException: This driver is not configured for integrated authentication

Usage: Eclipse Oxygen SQL Server 2017 SQL Management Studio 17.3 Microsoft JDBC Driver 6.0 for SQL Server Java jre1.8.0_151 x64 Windows 10 x64 Every time I run my program I get the following error. Error:    SQLServ...
asked by 08.11.2017 / 23:13
2
answers

What does the = * mean in the where?

Good afternoon, I would like you to support me with this. I have a query select ... FROM DBSosst..SRG_SUMMARY_NAVIGATION, SALDOS_prueba1 a WHERE GROUP_ID = 4 and STRUCTURE_ID = 1118 and SUMTO...
asked by 07.05.2016 / 00:33
4
answers

Concatenate two fields

I am concatenating two fields but it is showing me the end of one capo with the other. example: Pedro PabloCastro Ruíz SELECT documento, concat(nombres, '', apellidos) as datos, nacimiento FROM jugador     
asked by 12.07.2017 / 17:20
1
answer

How to generate a set of dates from a range?

I try to calculate the days of a range of dates, I have something of this style, however I get the amount of the range, my goal is to get the number of the day corresponding to the month. What it does Goal SELECT NOMBRE,R...
asked by 19.10.2018 / 00:18
2
answers

perform subtraction and show the values between 1 and 10

I have a table which contains I have this sentence to get me to subtract fewer exits: $sql="SELECT medicina_inventario,fecha_inventario,entrada_inventario,salida_inventario,total_inventario,inveObservaciones, entrada_inventario-salida...
asked by 09.11.2018 / 14:12
1
answer

Query does not return the expected values

Good morning, I have the following query: select Seg.NombreUsuario, count(RelA.IDSeguidor) as 'Siguiendo', count(RelB.IDASeguir) as 'Seguidores' from Perfiles as Seg inner join Relaciones as RelA on RelA.IDSeguidor = Seg.ID inn...
asked by 17.08.2016 / 16:50