Each user has a unique ID and an email and password. Of course, email is also unique. Currently, I have a id field in my mongoDB collection of user. For example, below is a document of a user. { _id:…
I have wondered about my current database design I made for my uni organization website. In general this website is for displaying informations and events. The event is different for each departement. It does some normal things like displaying event,…
I have these tables which are not related at all: Books Apps Cars Id Views Id Views Id Views ------------ ------------ ------------ 1 3 4 5 11 10 2 4 5 100 13 3 3 3 6 5 15 7…
I have problem cant exist catogaries : I want chek if the catogary is add before or not please i need help I have problem cant exist catogaries : I want chek if the catogary is add before or not…
DB::table('visitors') ->join('event_visitor', 'visitors.id', '=', 'event_visitor.visitor_id')->where('sex', 0) ->where('event_visitor.event_id', 1) ->count(); this is the query to get the count of men at the visitor's table with an event id of 1 I want to get the record count of men women and…
I've got 3 tables I need to work with: CREATE TABLE invoices ( id INTEGER, number VARCHAR(256) ) CREATE TABLE items ( invoice_id INTEGER, total DECIMAL ) CREATE TABLE payments ( invoice_id INTEGER, total DECIMAL ) I need a result…
I have a field called language in my table submission. Here the different user has submitted their problem with different language such as java(56) 5 times, CPP(45) 7 times, and python(71) 10 times. I want to have a query in…
I have a cart collection, which can have the same product with different variants. The problem is when I fetch the user cart and query for all those ids, when theres a duplicated one MongoDB is not including it in…
I have a Postgres database on Heroku and I want to have that database hosted on ElephantSQL, but I cannot for the life of me find how to do it. I have a DUMP file downloaded from the Heroku Postgres…
I'm a beginner to DynamoDB, and my online constructor doesn't answer his Q/A lol, and i've been confused about this. I know that the partition key decides the partition in which the item will be placed. I also know that…