I have table with over 35 million email records. I need to get all of the records between a date range and also exist at least 3 times in the table. 1 email may have more than one property but…
I unexpectedly executed the following query in MySQL and got a strange result: SELECT 'a' 'b' 'c' FROM dual; The result shows 'a' as the column name and 'abc' as the value. I am puzzled by this behavior. What is…
I have following 2 tables: Sales and Menu. SALES TABLE customer_id product_id A 1 A 2 A 2 A 3 A 3 A 3 B 1 B 1 B 3 B 3 B 2 B 2 C 3 C 3…
Table tblStudents columns: id, name, gender, SchoolName, SchoolId. Table tblSchool columns: id, name, location. select name, (select name from tblStudents as a where a.SchoolId=id limit 1) from tblSchool; I am looking to return SchoolName along with the first student enrolled…
For example, 2024-09-09 13:00:00 will be 2024-09-09 13:05:00 2024-09-09 13:00:50 will be 2024-09-09 13:05:00 2024-09-09 13:01:00 will be 2024-09-09 13:05:00 2024-09-09 13:04:00 will be 2024-09-09 13:05:00 2024-09-09 13:04:59 will be 2024-09-09 13:05:00 2024-09-09 13:05:00 will be 2024-09-09 13:10:00 The answers…
I am currently building a simple eccomerce platform using react, express js and mysql as database. now as i am retrieving data from the database to produce the products it does replicated it self into multiple instances like, product 1…
When I select all columns, the indexing does not work, but if I select just a few columns, it does. mysql> explain SELECT * FROM fatura USE INDEX (datapago_serv_pago) WHERE id_servidor = 10 AND pago = '1' AND data_pago <=…
I'm trying to use this to get contents of a specific table: let tablename = req.body.login connection.query('SELECT * FROM ?', tablename, (err, rows) => { if (err) throw err res.send(rows) }) But due to tablename being a string, it gets…
Wondering if it's possible to remove results with the same value. I have a payments table containing ADJUSTMENTS and REFUNDS entered as AJUSTE and ESTORNO. While both can exist in an invoice, if the total sum of each are equal,…
I want to sort/order a query in laravel. For example I have a model where 'id' ranges from 1 to 100. And I have an array of ids of selected model elements eg. [1,3,12,32,...]. I want to sort my model…