Questions tagged as 'sql'

Tagged questions
0
answers

When doing LEFT JOIN in MySQL, the data of the SUM () is altered

I have a structure of related tables. The main one is a table called MOVIMIENTO_ALMACEN with its column called CANTIDAD where it calculates the amount but according to the type of movement (" ENTRY " OR " EXIT ") and they make a s...
asked by 16.07.2018 / 23:36
5
answers

insert save all the records of one table in another more date parameter

I want to save all the records that contain a "table A" in another "table B" when pressing submith event "button save current period Currently, my main page already contains 2 forms and I thought that to avoid saturating my tables and edita...
asked by 16.07.2018 / 21:55
1
answer

Why does INSERT INTO not show me the data of the variable?

Hi, I'm trying to make a query in my php calendar by clicking, for now I'm doing fine. <left class="coordinar_left"> <select id="tipoEventos"> <option selected disabled>-Editar...-</option> <option...
asked by 02.07.2018 / 15:27
0
answers

Show the error when sending a form

I have a very strange case in sql server manager I have been ordered to work on a table that shows all the user fields in an editable form (that each data is a input ) Everything is fine but when I try to add a fifth column...
asked by 09.07.2018 / 19:36
0
answers

Subtracting a next value based on a condition in the same SQL column

I need to create a query that every time I find a value "Sent" in the Status column, then subtract it in the Events column taking into account a next value that is after Sent. Table that I am using: Catalogo Status Eventos ------...
asked by 09.07.2018 / 19:30
1
answer

FUNCTION GREATEST () IN SQL

MYSQL can handle a GREATEST() function which SQL does not have, and I try to change the following line of code: SELECT GREATEST(Efectivo,Cheques,Depositos,Tarjetas,Vales) INTO M FROM movcaja WHERE sys_pk=MovCaja; He managed to cha...
asked by 21.06.2018 / 18:32
0
answers

What is the correct way to load in a table data recovered with Spring, Hibernate and JQuery?

I am working with Spring mvc, hibernate with connection to SQL and I have trouble loading data on a table, which I have is the following. Pojo: public class Trabajador implements java.io.Serializable { private String idTrabajador;...
asked by 23.06.2018 / 21:35
1
answer

How to operate data in pyhon and sql server

My question may be quite simple. I need to make a sum of a column from my database. The problem is that (the way I do it), it brings me the data as rows and not as int. How do I get a data from the database as it is? Example: def prueba():...
asked by 21.06.2018 / 01:54
0
answers

how to make traces

I have an application whose database engine is the postgres and I have the pgadmin 4 installed but I need to know what tool to create a record of traces made by the user.     
asked by 22.06.2018 / 17:24
1
answer

I need to display all the identical records from Android Studio with SQLite

I have a database in an app in which I have registered the Names (VARCHAR) and an RFC (VARCHAR) of users. I have to do a search by entering a parameter in the two tables (Name and RFC), if there are repeated records, the list has to display all...
asked by 19.06.2018 / 06:30