Mysql – Order index for rows related to another table
I have a table that stores an id from another table, an index for a specific id and some different value user_id index_value some_value 1 0 01 1 1 02 1 2 03 2 0 04 3 0 05 3…
Mysql – Products with different prices and sizes
I find myself designing a database for a system for registering orders for a pizzeria. I have a table called "products" that contains these attributes: | PRODUCTS | | --------------------- | | id | int | | name | varchar…
operation is invalid due to current state asp.net
im trying to update my db doing: int index = grdExcUsePolicy.EditIndex; GridViewRow row = grdExcUsePolicy.Rows[index]; string id = ((Label)row.FindControl("lblId")).Text; String name = ((TextBox)row.FindControl("txtName")).Text; String created = ((TextBox)row.FindControl("txtCreated")).Text; if (gridUtil.getInsertMode()) { } else { GeneralDbExecuterService.executeSqlNonQuery(string.Format("UPDATE EXCEPTIONAL_USE_POLICY_PARAM SET NAME = '{0}', CREATED_DATE…
Mongodb – Mongoose is not connecting to local database
This is my app.js file. Please help me out to connect it with my local database. Sometimes it gets connected to the database and logs to the console but it doesn't add any collection to the local database. const mongoose…
Laravel eloquent find in array of objects column
I have a table called services with multiple columns and one column named staff_assigned with this content: [{"user_id":"15549","price":"100"},{"user_id":"15548","price":"300"},{"user_id":"15552","price":"95"},{"user_id":"15553","price":"600"}] How can I find all services where user_id is 15548 with Laravel eloquent? Note that Service::where('staff_assign->user_id', "15548")->get(); doesn't work because column contains…
How to display and update input values from the database on Laravel
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 =…
Mysql – Calculate difference in row values based on other row values in SQL
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…
Very slow query when using `id in (max(id))` in subquery – Amazon web services
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…
Retrieve the first and second best win results per age_group column per a region column in mysql table
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…
Mongodb – Model.findOne() is returning null
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 }); }); })…