I'm pretty new to SQL so sorry if this is a dumb question. I have a large table containing most of the counties from every state with a median home listing price. Each county/state has multiple observations because it has…
We have a table "url_rewrite" in our Magento 2 store and we need to copy a lot of values inside this table. We have a column "store_id", that contains values from 1 until 4. Another column with "target_path" and the…
I have a table with the following example data: ID Name lat long 1 100 123 -123 2 101 234 -234 4 100-L NULL NULL 5 100-R NULL NULL 6 101-L NULL NULL 7 101-R NULL NULL What I need…
I am writing a PostgreSQL trigger function that will allow me to do an ETL transformation on a data. I have a table with fields (id, price, EFF_FROM, EFF_TO), and if I only insert (id, price, EFF_FROM), EFF_TO needs to…
I have a huge table with over 10M rows. I need to update the following rows: select * from customers_card_psp where status="not_added" and psp_id = 2 order by id limit 50000 Since I have a composite index on customers_card_psp(psp_id, status),…
I am trying to update a column in MySQL, where it contains a json encoded value with multiple key-value pairs, but cannot write the exact query. Can anyone help? For example: tableA: id response 1 {"event_id":"11111","contact":{"contact_id":"as2344","answers": [{"answer_id":"2223e"}],"tags":"cadd76","question_id":"67888"} From the above…
Here is the structure of the 2 tables: This is the "main" table : CREATE TEMP TABLE final_table ( idx INTEGER, pids INTEGER[], stats INTEGER[] ) INSERT INTO final_table VALUES (2733111, '{43255890, 8653548}'::int[], '{4, 5}'::int[]), (2733112, '{54387564}'::int[] , '{6}'::int[] ),…
In my Postgres 13 DB I want to update a column mother_tongues_id in my table based on name columns. Names are like "Le Minh Thien" and I want to check if those contain words like 'le' or 'lee' then set…
In PostgreSQL, I have a table named users with data that looks like so: id favorites 1 { "shapes": ["Triangle", "Square", "Rectangle", "Circle"] } 2 { "shapes": ["Rectangle", "Triangle", "Circle"] } ... ... Where favorites is a JSONB column. I…
In PostgreSQL, I have a table named users with data that looks like so: id favorites 1 { "shapes": ["Triangle", "Square"] } 2 { "shapes": ["Rectangle", "Triangle"] } ... ... Where favorites is a JSONB column. I want to add…