I need to insert data into new table person_department using recursion. My tables for now: person id group_id 800 10 805 21 department id name group_id parent_id 1 ABC 10 5 2 TY 11 5 5 OOO null 9 6…
we want to "fill in the gaps" of the record_ids and fill in missing values with the most recent available value. If there is no value available, use the first available value instead. The result should look like: category record_id…
id_start id_end 1 2 2 3 3 4 I want to collect elements who are "connected" like [1, 2, 3, 4]. (in an array for example) I tried a recursive query like: WITH RECURSIVE q_rec AS ( SELECT id_start, id_end…
aid bid 1 2 1 3 2 3 3 4 5 6 7 8 8 10 8 9 I would like to extarct the hierarchy linkage for aid and bid. No need to show each path, any id should show…
Table "skus": plant_species_ids 1,2,3,2,3,1 Table "plant_species" id name 1 Plant 1 2 Plant 2 3 Plant 3 The relevant part of my MySQL code: ... GROUP_CONCAT(plant_species.name SEPARATOR ', ') as plant_species_names ... LEFT JOIN plant_species ON FIND_IN_SET(plant_species.id, skus.plant_species_ids) > 0…
Situation: Imagine some script that, upon completion, inserts the current timestamp and some other data into a MySQL table. It's executed every thirty minutes, sometimes not at all, leaving gaps in the data. Goal: Have a query that fetches all…
hello i have table profile that has many attributs, and the profile has on parent but the parent can have a parent etc.. I want to get all the list of the attributs(even the attributs of the parents) i wrote…
I have a representation of a (binary) tree as a table in PostgreSQL. Each row is a node of the tree and each row has a parent column and a color. The nodes at he leaves of the tree have…
I have 3 columns as user_id, start_date, end_date. as an example; user_id start_date end_date 1 2022-07-30 2025-07-30 2 2022-05-25 2027-05-25 I want to create rows based on start_date and end_date with yearly laps on the same date. so it should…
Say i have the following table, called graph: _id relates 1 {2, 3} 2 {4} 3 {5, 6} 4 {3, 7} 5 {} 6 {} 7 {} Here it is in graph form: graph My problem is to write a…