I have this mysql table
As you can see in the day column I have two days "po" and "20", what I need is a query that returns me the number of days that are registered, which in this case is 2.
I have this:
SELECT COUNT(*) AS total F...
I have a question with a query, I need to make a query that shows me the most recent date of the registration of a price of a product that has a record of several prices with different dates, I just want to obtain the most recent date for each p...
good and tried in different ways to try to group a sum of 3 tables
I will write the example to be clearer
SELECT
v.fecha_ven,
e.apellidopaterno_emp,
e.nombre_emp,
SUM(d.precio_dv * d.cantidad_dv) AS Total
FROM
detalle...
I'm with a basic project of a phone book with a series of data in which there are a series of requirements.
Spring boot
Thymeleaf
mySql
jpa
The project is advanced but I find the following problem, users must have a province from...
Good I'm doing the order editing and I bring the data through GET. There is a field in the table called Iduser which is the user who has placed the order.
Then to edit the order I get a select with all the users that I have in the BD....
I have a theme table, which can have several photos, and I also have my publication table and can also have photos, how could I reuse my table photos, to use it in the publication table? .thanks in advance
I am developing a project in which I have to save several files from a table, I can save them the problem is to update or edit I can not do it I get this error
"Argument 1 passed to Illuminate \ Database \ Grammar :: columnize () must be
...
Well I try to make it in a datagridview by selecting a date from-to show me the records between those dates I'm using between to do this and the truth because I could not have this in a form with a datagrid, 2 datepickers and a search button...
I need to know how I can insert an array (that was obtained from a MySQL query) to mongodb (it should be inserted in the same way in mongodb as an array), this is what I have done but it does not keep me as it should be.
public function create...
I have a selectbox populated from mysql from a table with two fields (id and name). The selectbox shows the list of names. I need that when selecting an element of the select send the id to an input text and the name to another input text.
For n...