I'm triying to add quantities of fuels from two tables. Payments table contains data about customers and dates. Fuels table contains data about fuels recharged. I need to add the litres by customer in 3 groups: from yesterday until 46…
I've looked through SO, and there are similar questions, but I can't seem to figure out how to do what I need. For the purposes of this question, my table has 3 columns: reconciled (tinyint), datereconciled (timestamp, CAN BE NULL),…
I have a table named deposit, below dep_id deposit_amount comp_id 1 100 1 2 100 1 3 100 1 When I run the query below I get the next updated table which is not what I want : query =…
I have the following mysql query: SELECT pagos.id, codigo_factura as code, pagos.importe as amount FROM pagos INNER JOIN m_labores p ON (pagos.id_producto = p.id) INNER JOIN maquinas m ON (pagos.id_maquina = m.id) WHERE m.id = 561 AND fecha_registro BETWEEN '2022-10-11…
So I have two tables: CREATE TABLE table1 (`PRIMARY_DT` date, `CUST_ID` int) ; INSERT INTO table1 (`PRIMARY_DT`, `CUST_ID`) VALUES ('2012-03-02', 878 ), ('2012-07-02', 456 ), ('2012-09-02', 789 ) ; CREATE TABLE table2 (`dt` date, `CUST_ID` int, `value` int) ; INSERT…
I'm trying to deploy a MySQL docker image, create a database, and test-run my migrations and seeders although its complianing it just can't access the MySQL server running on 127.0.0.1:3306, is there something I'm missing? I get: #!/bin/bash -eo pipefail…
I am seeking to find first date of the month in the corresponding table: So if i have 26/08/2011 August as date and 2 months to add, it becomes 26/10/2011. I need the first date of the resulting month- like…
I have a Mysql query that fetch monthly records from DB to use to draw a graph. If there is no enough data to cover the whole year (12 months) the graph will be drawn with only 2 months. This…
I'm trying to write a query to look-up rows which contain one or more of comma-separated values. Please see scenario below: Table: Events, target row to lookup is called "courses" The data in the courses column is a comma separated…
I need to export posts and content from an old WordPress Site for a customer, to import on their new website. Is there a way to run the old website on my local host? Or is there a better way…