Am displaying user profile data from the database to an input field and at at the same time, the user should be able to update the input field Controller.php // shows details in input Public function details() { $id =…
I want to calculate the difference between endTime and startTime for their corresponding IDs and display ID and duration(calculated field) without having to create a new table in SQL. I have tried ordering the table and using LAG and LEAD…
We recently moved our database from MariaDB to AWS Amazon Aurora RDS (MySQL). We observed something strange in a set of queries. We have two queries that are very quick, but when together as nested subquery it takes ages to…
MySql issue: I want to extract the two best age_groups per region based on their wins. I haven't had much luck on this, having browsed similar issues. It's probably straightforward but mysql isn't playing nice for me this evening. region…
Model.findOne() is returning null even if the valid collection is present in the respective Model app.post("/fleetManagement", (req, res) => { const requestedDriverID = req.body.driverId; console.log(requestedDriverID); Driver.findOne({ _id: requestedDriverID }, function(err, requestedDriverResult) { console.log(requestedDriverResult); res.render("fleetManagement", { reqDriver: requestedDriverResult }); }); })…
I have a huge mysqldump file (~700GB) that I want to restore on a different server. For the first GBs, the import is quite fast with some MB/s, but after some GB of data, the speed drops to something between…
Assuming that I have 20L records, Approach 1: Hold all 20L records in a single table. Approach 2: Make 20 tables and enter 1L into each. Which is the best method to increase performance and why, or are there any…
So I have a table of 4.7 billion records on which I want to perform a group by count expression in Postgres using PGadmin4. Obviously this is gonna take a lot of time and I want to speed up the…
I need a report of which cars (license plates) are parked in and when. This is an example of my table. id lic_plate datetime lane _________________________________________________ 10 1234-JM 2022-10-07 12:24:33 IN 11 1234-JM 2022-10-07 12:29:57 OUT 12 5678-PC 2022-10-07 15:14:17…
I have this membertype table: | member_id | member_name | |-----------|-------------| | 901 | Liz | | 902 | Margaret | | 903 | Bob | and this revenue table: | GIS_ID | Member_ID | Total_Revenue | Total_Discount | Number_Transaction…