I'm trying to connect to my Mariadb database that's inside a Docker container. I've looked at Microsoft's documentation and searched on Google to find out why I'm getting an error message saying that there's nothing to retrieve from the database.…
I have a compound index on 3 columns. Now I want to execute the query based on only 2 columns, which both are not indexed. So the query takes long time to execute. How to I make use of the…
I have two queries that I want to run against a certain type of product, to check whether a product exists with certain specifications. Therefore I first want to check if a product contains a type=A, and if so check…
Data: user_choices table id userid choices 1 3 1,2,3 2 55 5 3 783 2,6,7 4 45 1,4 5 5 1,2,3,4,5,6,7 How can I query this table to explode the choices column filtered only to show values 1 or 2…
I am very much new to SQL and have been given an exercise for homework that sounds when translated like this: "For each column type find the number of tables that do not contain this type of column". I know…
I'm trying to execute the triggers.sql file. Below is my prisma.schema and triggers.sql file code. I've already migrate the prisma schema and generated it as well. So when I'm running the command npx prisma db execute --file ./prisma/triggers.sql in the…
Example table with one column tmp_year_test.year and values: year 2010 2011 2012 And now the logic -- 2010 - OK select max(year) over () as max_year from tmp_year_test where year = 2010 -- let's put it in the view create…
I am trying to write a query where I select records by some condition, update one column of those records and then return them, all in one transaction. I have tried two options. First with CTE: BEGIN; WITH unwatched_rows AS…
I have created alarm that insert into database based on type of event at the same time. I did query select * from alrm where ble=$bleAddress and datetime=(select max(datetime) from alrm to get the list of data from alrm table.…
I want a way to show SQL query how it will look with anonymous parameters (?) substituted by actual parameters. This is only for readability purposes and debugging, and wouldn't be used as an actual query. I have found this…