I'm trying to use MySQL and jdbc, but I can't use the executeQuery command, do you know why? It's the first time I've programmed in Java and integrated SQL into the program, I don't know what's wrong. import java.beans.Statement; import…
I am not sure on how to begin optimizing this High Latency SQL query that my platform runs. Other than reducing the datasets, what are some things that I can do? SELECT ctm.* FROM compound_transaction_map ctm JOIN bustransaction_map btm ON…
In this code, the #searchInpForm search box gets cleared but the data that is called by my getAllPersonnel() function doesn't refresh. It refreshes if I don't include the line about emptying the search box. Also, the function gets called but…
This is my model. class JoinedResults { final int? id; final int? question_id; final String? question_text; final String? question_type; final bool? is_mandatory; final int? correct_option_id; final int? option_id; final String? option_list_text; JoinedResults({ this.id, this.question_id, this.question_text, this.question_type, this.is_mandatory, this.correct_option_id, this.option_id, this.option_list_text,…
Let's assume there is a following table: CREATE TABLE time_interval ( id SERIAL PRIMARY KEY, start_time TIMESTAMP NOT NULL, end_time TIMESTAMP ); Sample data: INSERT INTO time_interval (start_time, end_time) VALUES ('2024-02-10 01:30:00', null), -- pending ('2024-02-10 03:00:00', null), -- pending…
I've got a table in my database that contains a bunch of JSON paths and the values at those paths. I want to take the data in that table and construct a JSON object out of it. I'm more of…
I want to add this query to a column in my table.I am using pgadmin select customer_id, count(*) from summary group by customer_id order by customer_id asc I got as far as ALTER TABLE summary add sum_of_rentals INT UPDATE SUMMARY…
I am trying to write a stored procedure to get an employee by input ID. In SQL Server, it looks like this: CREATE PROCEDURE [dbo].[GetbyID] (@ID NVARCHAR(50)) AS BEGIN SELECT * FROM dbo.Employee AS M LEFT OUTER JOIN dbo.Position AS…
I have a schools table, I also have a school_relations table. The issue is i want to only show once relation between schools and not have to repeat it the other way round on the table of the relations. Here…
I am working with a MySQL database and I have a column (let's call it status_column) which contains comma-separated values. The possible values in this column are 'NA', 'NON_NA', 'PSG_REQUIRED', or any combination of these, such as 'NA,PSG_REQUIRED' or 'PSG_REQUIRED,NON_NA',…