Composite Key on DynamoDb
I have a single dynamodb table. One of the type records is called "Result" and one of its PK stores a composite key (class, student and exercise). This is the example design: PK SK SCORE ... GSI PK 1 GSI…
Mysql – SQL How to select original(distinct) values from table without using distinct, group by and over keywords?
Currently I'm studying and I received task to write query (join 4 tables: people, goods, orders and order details). So main table Order_details has two columns: Order_id and Good_id, in order to make possible to have many goods in one…
Mysql – Can someone optimize this SQL query?
I am currently working on a project that has 2 very large sql tables Users and UserDocuments having around million and 2-3 millions records respectively. I have a query that will return the count of all the documents that each…
How do I update data in the database in laravel?
This is the code I have written so far: Here is my Controller that contains the edit and update function: public function edit($id){ $post = Posts::find($id); return view('edit', compact('post')); } public function update(Request $request, $id){ $post = Posts::find($id); $validatedRequests =…
Mongodb – how to Push item into array via mongoose?
I'm looking to push this ObjectId from the Notes Schema: 635b70c1121186eefbbc5718 into the 'notesId' of this other Category Schema: { _id: new ObjectId("635b70c0121186eefbbc5714"), name: 'frenchLessons', creator: new ObjectId("635aa97815faaa052ae9cfce"), notesId: [], __v: 0 } What I did was that I found…
Keep mongoDB client connected Golang
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…
Set AutoIncrement value with Subquery in MySQL
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…
MongoDb is connected but cannot store title and body
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…
MYSQL how to group by specific value?
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…
Sorting values in ascending order based on number and year in MySQL. The oldest year and smallest number value means the record shows up first in asc
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…