We have a table called "subscriptions" that stores information about salon subscriptions. The table has the following columns: subscriptions id, start_date, end_date, subscription_plan_id, salon_id We want to write a query that provides the following information for each month: Date Total…
I have the following structure in the database: { "_id": ObjectId("6464acb09947e03e45b78b61"), "ProjectId": "64635ac02286d48c0c0d5907", "LabelValues": { "62d12558d75c134f54911490": "Nicht zuzuordnen", "62d12546d75c134f5491148f": "Nicht zuzuordnen" }, "KnowledgeItemId": ObjectId("6464acaf9947e03e45b78b60") } I want to write a query, that gets this element if I pass the two…
Basically, I am trying to create a tag search system for images, in which each image has an array of tags within a jsonb field image_data, like so: id image_data 1 {tags: ['landscape', 'dog']} 2 {tags: ['landscape', 'cat']} 3 {tags:…
In a PostgreSQL 14 database I have a transactions table currently containing around 400 million elements and the following query on it: SELECT "transactions"."id" FROM "transactions" WHERE ("wallet_id" = $1) ORDER BY "transactions"."id" DESC LIMIT 10 This works fine and…
Following the Firebase Database Setup, I can't Read/Write anything. I've been googling for hours trying different approaches and nothing is working. I'm using Discord.js so I'll remove the stuff unrelated to Firebase. For now I'm just hard coding the values…
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; public class App { public static void main(String[] args) { App pro = new App(); pro.createConnection(); } void createConnection(){ try{ Class.forName("com.mysql.cj.jdbc.Drive"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "root","root"); System.out.print("testinggg"); }catch(ClassNotFoundException…
I work with XYZ PHP Code WordPress plugin. Why this code dont't work? Table structure: id (int, AI), name (varchar), mail (varchar), message(varchar), date (datetime) if(isset($_POST['add']) && $_POST['name'] && $_POST['mail'] && $_POST['message']) { global $wpdb; $name= $_POST['name']; $mail= $_POST['mail']; $message=…
I am connecting the instance of AGE running on WSL to AGE Viewer running on Window. It is working fine. When I run query: SELECT * FROM cypher('university', $$ MATCH (v) RETURN v $$) as (v agtype); It works fine…
I have this case where we have different queries we want to run in SQL Server then save it in an Excel file. I parameterized the Excel dataset I have then assigned it in the "Sheet name" property but I…
My application has a myriad of queries and I wanted to get the execution plan of some of them. Most if not all of the queries have multiple parameters and I can't find how to get the execution plan for…