All Questions

in node, i'm creating the following query: let sql_query = "\ SELECT \ ... \ WHERE \ FACILITY_ID = $1 \ AND (EVENT_START_TIME_UNIX_MS < $2) \ AND (...

I have a Spring Boot application that connects to an Amazon Aurora MySQL-compatible database. The setup uses the MariaDB JDBC driver, the AWS JDBC wrapper, and HikariCP for connection pooling. My code ...

I have a table with 200 columns. I am trying to prepare an "insert into this table" from excel file to a database table. I should put 190 question marks more. ps = con.prepareStatement("...

When using the NodeJS mysql2 library, I am trying to understand the differences between Connection.execute and Connection.query. As I understand it, query prepares the statement locally and then makes ...

I'm trying to use the multi row insert with postgres INSERT INTO table_name (column_list) VALUES (value_list_1), (value_list_2), ... (value_list_n); on a list of Strings that can of course be of ...

I am trying to use MySQL CONCAT_WS in a PDO Prepared Statement. I tested the query inside of phpMyAdmin and it works perfectly but not in a PDO Prepared Statement. Here is the phpMyAdmin query which ...

I'm getting myself confused I think, but I am trying to update a value in a JSON object (jsonb column) of a psql database like so func updateProfileLessonProgress(userID string, lessonID, currentSlide ...

For my work i need to create several PrepareStatements which are inserted in my table. Normally i have no problem with this, but this problem don't make any sense to me. I work in a give environment ...