I have a Spring boot app with custom queries. I need to find all database rows according to condition - if :myFlag is true, field in database must be in a list (:values here), or null. Can I use something…
I need a result of an array that is flattenened like this: $result = ["1", "2", "3", "4", "5", "6", "7"]; I have a DB result of this query: $articles = DB::table('articles') ->where('is_published', 'true') ->get() ->pluck('category'); When I do this…
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'eshop.sessions' doesn't exist SELECT * FROM sessions WHERE id = N7H5CpGFStKcjjHhlq9aOo05OE0eU2I9muBXC4Tc limit 1 enter image description here When i check my database i have no table named sessions (never had by…
setup: aws rds mysql aurora Our DB has a writer and a reader instances. If we use the reader instance(which has a separate CPU) will large read requests have any affect on the Database that the Writer instance is connecting…
I have millions of rows of data in MySQL DB. Can you suggest me any services or platforms that support JOINS and fast data retrieval. I have looked on elastic search and manticore search, but these don't support JOINS. So,…
i want to get the order id maximum by the relative user id $order_id = "select * from products_orders where order_user_id = $user_id AND MAX(order_id) "; $ord_del = mysqli_query($con,$order_id) ; $ord_row = mysqli_fetch_assoc($ord_del); i try this method but this wont…
Lets say I have 2 tables: User: ID: PK, AI username: varchar pwd: varchar addressID: FK references address.ID Address: ID: PK, AI street varchar, houseNr varchar, postal varchar, How would the history tables look like since we obviously have foreign…
I use Prisma and Postgresql for a project to store and manage recipes. I am struggling to implement a Many to Many relationship where I can constrain one side to require at least one value for the relation field. Recipes…
I'm encountering an issue with fetching data from my database in a production environment. The code works perfectly fine on localhost, but when deployed to production, it fails to retrieve updated data. Here's the relevant code snippet: import {connect} from…
Here my design database, I working on E-commerce project So when the admin create a new product its have new Id and the user have to select the color and size for the product. The problem is when create a…