I want to query a table with multiple combined fields in an IN clause. Example: find all records with "john doe" and "marc smith", but ignore all other persons.. SELECT * FROM persons WHERE firstname IN ('john', 'marc') AND lastname…
I have a flyway script which creates a User in postgres with an encrypted password. I want flyway to create the user account, and then use the account with a springboot java application. I want to use an encrypted password…
I'm confused a little bit about how I can import a custom .sql file into the default db as soon as it gets ready. I tried putting an import command under .ddev/commands/web but didn't work out. Thanks in advance I've…
I have two tables job_report and index_jobreport. job_report table "id" column is "index_jobreport.jobreport_id". index_jobreport have DSR_hashkey column. We group the DSR_hashkey column with the main query. This time query is getting random rows from time to time. (attached files -…
I have a query like this, SELECT colA, colB, colC, colD FROM myTable ORDER BY colC ASC; Here, in myTable, all the values in the column colC are Empty/Blank/NULL. Now, how MySQL will behave in this scenario? I know the…
Hello I have a project table which has a field name in my db which is multi lang so I stored it as json so I can store each lang value the problem is that the arabic lang is being…
I'm trying to upsert a post: DROP FUNCTION IF EXISTS upsert_post; CREATE OR REPLACE FUNCTION upsert_post( title text, content text, short_id text DEFAULT NULL, image text DEFAULT NULL, status post_status DEFAULT 'draft', updated_at timestamptz DEFAULT NULL, published_at timestamptz DEFAULT NULL,…
i have this model data structure: type Order struct { OrderEntry OrderEntry `db:"order"` } type OrderEntry struct { Order_uid string Track_number string Entry string Delivery Delivery Payment Payment Items []Item Locale string Internal_signature string Customer_id string Delivery_service string Shardkey string…
I have two tables - jobs, and jobEntries jobEntries has a jobId that maps to jobs, but wasn't set up as an "official" foreign key relationship so I can't use CASCADE DELETE. For each job, there are many jobEntries. I…
I'm trying to open a SQL template in Python which creates a database with tables and excutes using pymsql. However, I keep getting an error. import pymysql import Settings with open('Settings/databasetemplate.sql', 'r') as sql_file: sql = sql_file.read() conn = pymysql.connect(host='*****',…