I try to understand why my mongoDB client disconnect despite the global scope variable. There is something that i dont understand. I think, somehow, this is related the ConnectToDatabase() function. If i try to do some operation on the DB…
I am trying to provide the value for auto increment value through the subquery in mysql I tried with this command alter table xxx auto_increment = (select max(id) from xxx) ; But am getting the syntax error as You have…
I am a beginner and starting to learn MongoDB, NodeJS and Express by creating a simple blog project. I facing a problem as my data cannot be stored in my MongoDB event though my MongoDB connects properly. There may be…
Let's say I have a table like this: id | amount ------------------------- 1 | 10 1 | 10 2 | 20 2 | 10 3 | 20 3 | 10 3 | 10 4 | 10 Let's say id 1…
I'm trying to sort a MySQL table data based on a column values. id record_number created_at updated_at 1 ent/4/2022 2022-10-24 20:34:25 2022-10-24 20:34:25 3 ent/6/2021 2022-10-24 20:35:03 2022-10-24 20:35:03 The column is named record_number and the values of column follow…
I am upload project file to Sub Domain. But In web site,just project files is showing. Project is not execute. How can i resolve this problem ? Subdomain is active.
I've built a simple website with authorization and registration system. So I have user accounts and I wonder where to store profile pictures for every user. I tried to store them in MYSQL in BLOB, but I don't think it…
i want to search a date like the following: 09-11 03-22 and it will search in the available documents and bring the matched documnet. an available document example : 2022-09-11T15:31:25.083+00:00 how can i do this? i tried following query but…
This is a simple REST API for listing, creating and deleting products in/from database. I am having issues with validating/checking if certain values duplicate or if certain input field is not filled. I've attempted doing that with rowCount for the…
I have this query in Postgres that returns a hash value for every row of my table: SELECT md5(CAST((f.*)AS text)) FROM my_table f; I want to attach each hash to its corresponding row. How would I take the results for…