i want to count how many times the code is repeated in each query without the last 3 letters. The capital letters in the code column is what i need. IDs Code 58112 DFGH dds 25554 JIIK sdf 58112 ABCD…
I need to normalize (in a technical way) table1 by splitting the column "error occured at" so that it was like in table2. Is there is any DML function that will help me solve this? So that the rest of…
I'm having a problem updating tables in a MySQL database (InnoDB). I have three tables 1-orders Table orderId userId status 7 4 bending 8 4 bending 2- orderedProducts orderId productId quantity 7 22 1 7 24 1 8 22 2…
I have a data like under mentioned in table in one column name remarks Will0017,Will0018, Kind0045 , DGRG0012 I want to extract only numbers from the same only like 0017,0018,0045,0012 How can I do the same in mysql. I have…
Seems like I'm missing something very basic here. Trying to run a dynamic SQL query that will return a resultset. if I run this, it will return run successfully, but return nothing: DO $$ <<outerblock>> DECLARE p_sql text; BEGIN p_sql…
Based on the initial question where I needed the counter PostgreSQL select self referencing with two columns in addition to the counter I need data from the client and consultation itself, here is the better question to what I need…
I have a table as follows. It consists of many customers (only showing one customer, James, here for simplicity) who can have many accounts. Each account has a balance every day. My goal is to get all the dates for…
I wanted to create a query based on the date, I want to sum the credit and debit based on the year of the transaction_line and display it as total_previous (date within 2021) and total_current (date within 2022). Below is…
I have a table for formula grade where the user can create their own formula using the operator, column, dan number, which I have provided on app UI formulaid tipe formula gradecatid 1 operator ( NULL 1 column PAS 5…
I'm struggling with this for a while now and can't seem to figure it out. I have a clients, relations (which define relations and their type between clients) and consultations. What I wan't to do is count how many consultations…