Postgresql – SQL count by column values
I'm trying to count multiple values in multiple coluns in a table and I did that: TABLE id risk record api 1 OK OK NO 2 OK OK OK 3 OK OK OK 4 OK NO OK 5 NO OK…
How to connect to a database running in docker in a digital ocean droplet remotely?
I have airflow and postgres running in a docker container that I have hosted on a digital ocean droplet. Airflow is running successfully and writing data to my postgres database. When I ssh into my digital ocean droplet, I can…
Using a CTE to delete Nulls Shows Error [1292] [22001]: Data Truncation: Truncated Incorrect DECIMAL – Mysql
I am trying to find a way to delete all rows with NULL values in a table. On this post, I saw that you can't specify a target table from updates in the FROM clause. Therefore, I tried building a…
DBeaver CSV Import Transform Expression – Postgresql
I'm trying to import a CSV into an existing PostgreSQL table using DBeaver Import Tool and I need to transform a numeric value multiplying it by 100. Someone knows the syntax to be used in the expression? The official documentation…
How to create a View with joint and the column used to join? – Mysql
So I am trying to create a View by joining 3 tables (FlavouredBeer, BeerInfo & FlavourNotes) by the beerId in 3 tables. However, I cannot select the beerId column that I think it's useful to be shown. CREATE VIEW FlavouredBeers…
Amazon web services – Why does LEFT OUTER JOIN produce the same results as INNER JOIN in DBEAVER when querying from Redshift?
I have 2 tables. t1.uuid has 630,000 distinct values. t2.uuid has 300,000 distinct values. When I run SELECT t1.uuid , t2.uuid FROM t1 --630,000 uuids LEFT OUTER JOIN t2 -- 300,000 uuids ON t1.uuid = t2.uuid WHERE t2.uuid IS NULL…
Trying to get only cells with certain initials but giving me syntax error? SQL – Phpmyadmin
So my assignment question is to "Get a list of all books withdrawn by people with the initials 'B.W.'. Show a column for the first name, last name, initials, and the title of the book". I am trying to join…
How to connect to DB2 running on docker
I have installed the image ibmcom/db2 on docker running on local Docker Desktop on Windows 10. Following this guide to setup: https://www.ibm.com/docs/en/db2/11.5?topic=system-windows I am able to query the sample DB from the db2 command prompt, as described here: https://www.ibm.com/docs/en/db2/11.5?topic=windows-testing-your-db2-community-edition-docker-image-installation-systems The…
How to connect to MySQL database cluster – Docker
I tried to install a MySQL cluster with the Docker image below. mysql/mysql-cluster - Docker Image | Docker Hub The Docker image is pulled and run successfully. Despite that I could connect to the cluster in the terminal (as shown…
connect docker postgres from outside (DBeaver)
I am using Airflow through Docker-compose. The same docker-compose.yml has an image of Postgres as well. The config looks like below - postgres: image: postgres:13 ports: - 5432:5432 environment: POSTGRES_USER: airflow POSTGRES_PASSWORD: airflow POSTGRES_DB: airflow volumes: - postgres-db-volume:/var/lib/postgresql/data healthcheck: test:…