i have some records on mysql db, i tried to group by month, data is correct but time of March month is showing as "2022-03-22", i required as same as other months like 2022-03-01. time month_name inc_number 2022-01-04 19:58:09 January…
Given a column named fullname, how can I filter on firstname/lastname with no order ? In the example below in javascript, the query is not valid when searching by lastname function getQuery(searchWord){ return `SELECT * FROM user WHERE fullname like…
very new to JavaScript and API building. I'm writing a simple address verification system and I'm running into an issue where the response sends the buffer data in addition to the response of the columns that I want to query.…
If i modify the max number of allowed digits in MYSQL 5.7 from double(8,2) to double(12,2), is the change immediate or will it need to process all rows??
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…