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...
I'm making a data set for an application, and when I insert a Time record, it gives me the following error:
INSERT INTO [ope_prodqa_dev]
(
staff,
turn,
date_prodqa,
hour_dev
)
VALUES
(
1,
4...
I have a problem with showing some data in a select button, it happens that by default it always shows me the first one in the row, I made the test by entering different values in the database, it takes me but not listing it. When entering a new...
I have a query that I can not work inside codeigniter, removing parts of the query, it seems that the error is in the JOIN, but I do not understand why, and even less understand, that when performing the query in PostMan, for example, it does n...
I have a question and I do not know how to solve it ...
I'm with my first project in Laravel and when I make an insert with the query builder of a field that was a multiline textarea, it removes all the line breaks.
How do I keep it?
Greet...
I have this query but I like to add the number of calls and the sum TMO per hour example so I want to do it:
usuario 8 9 10
cantidad|tmo cantidad|tmo cantidad|tmo
juan 20 | 45.20 20 | 10.3 52...
. Tables involved:
data_incidence
data_ticket
I try to execute this query:
select t1.fecha_carga, t1.hurtos, t2.fallas, t3.ticket
from (select count(ttc) as hurtos, fecha_carga from data_inciden...
It returns only one record and in my DB there are 3. I suspect that the problem may be in the query, with the theme of concatenating tables.
Here my sentence:
SELECT
productos.nombre,
productos.name,
productos.precio,
categorias....
Hi, I'm doing this page web where I have some courses that I upload directly in Post type courses but I have to filter them in this page that I attached above.
The site is made for two countries Mexico and Argentina and I need the people of Me...
Hello, good morning, I request a help or guide to try to solve a query in sql, it should be noted that I am new in this world; I am trying to make a query that shows the last record by item code that is to say I have values such as item code, da...