I have a table needs to be partitioned, but since the postgresql_partition_by wasn't added while the creation of the table so am trying to: create a new partitioned table that is similar the origin one. moving the data from the…
I'm confused what is the relationship bewteen customer and a order. Most of websites says its One to many because One customer can place many order. If we see physically its many to many because there is customer and there…
enter image description here How to count notifications with a certain status and a certain user_id ? I have some data in notification table, how is the logic to calculate notification whose status is field 3 based on user_id 2…
This is Ahmad Raza. I'm working on E-commerce Project. I am trying to get product attributes on Product details page where user can select attributes before adding to cart. I have two color attributes of single product in my database…
I want to create a table. I'm having long and hard time about naming columns. If there are 3 columns having same characteristics. ex) tag_1, tag_2, tag_3 -> CREATE TABLE BOARD ( BOARD_ID bigint not null primary key, TAG_1 varchar(10)…
I am trying to connect to a sample database I have created in Azure using C# (.NET Core 3.1) I have enabled my IP address within Azure's Firewall rules. I am able to use VS2019's SQL Server Object Explorer to…
I am building an application using MongoDB Atlas as the database and Django REST Framework on the backend. I'm trying to initiate the connection between the two, however, I keep getting this error back: Error connecting to MongoDB: 'ag-lfgx9hg-shard-00-02.glqs5bt.mongodb.net:27017: [SSL:…
I'm trying to display a data by month and displays the product with the highest value or bought quantity. But I don't know how I should do it. This is the code I have and tried so far public function…
Is there any way that I can see what is stored in those indexes? I understand the query mentioned below lists down all the schema indexes and their details: SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'your_schema'; (taken…
How can we optimize the delete query. delete FROM student_score WHERE lesson_id IS NOT null AND id NOT IN(SELECT MaxID FROM temp) ORDER BY id LIMIT 1000 This select statement return "SELECT MaxID FROM temp" 35k lines and temp is…