I don' t know how to insert a row in the child table that has an attribute that references to the column ID (primary key of the father Table)in the same transaction because i dont know the father primary key…
I have a table of properties: +----+-----------------------------+ | prop_id | prop_name | +---------+------------------------+ | 1 | Cottage | +---------+------------------------+ | 2 | Mountain House | +---------+------------------------+ | 3 | Beach house | +---------+------------------------+ A table of accessories: +----+-----------------------------+ | acc_id…
I need to make sure we have support to create a hierarchy table based on a "father/son" table. Example: F S a b b c b d b e e f e g b m z n m k Expected…
I want to split a character string is part of the comma but the orca I try my code below it only returns me the index of the first comma and not the different strings fraction of the sentence DELIMITER…
on mysql I see this error but can fix it. Anyone can help please? select * from ( (select a.* from sessions as a) join ( select b.customer_id, min(b.timestamp), b.marketing_source as first_touch_source, b.marketing_medium as first_touch_medium from sessions as b group…
I have a table with payment history payments: id consumer_id amount created_at 1 1 30 2021-05-11 13:01:36 2 1 -10 2021-05-12 14:01:36 3 1 -2.50 2021-05-13 13:01:36 4 1 -4.50 2021-05-14 13:01:36 5 1 20 2021-05-15 13:01:36 In final result…
I'm trying to transform a PostGreSQL Query in Laravel Query Builder Syntax, but isn't working SELECT users.*, rifs.rif FROM users JOIN rif_user on users.id = rif_user.user_id JOIN rifs ON rifs.id = rif_user.rif_id WHERE email = '[email protected]'; $busq = DB::table(['users','rifs']) ->select('rifs.nombre','users.email','rifs.rif')…
I am trying to debug a query that runs faster the more records it returns but performance severely degrades (>10x slower) with smaller returns (i.e. <10 rows) using small LIMIT (ie 10). Example: Fast query with 5 results out of…
I would like to filter my query with only closed months, so today (17/11/2022) would return only 31/10/2022 and before. I have tried the following: WHERE EXTRACT(MONTH FROM dc.data) <= (EXTRACT(MONTH FROM CURDATE()) - 1) So I get the current…
I have a single table with ~ 1.5 mio entries and this query: SELECT id FROM abc.items as I where revisit < '2022-11-17T00:00:00Z' AND type = 10 AND firstdelivery = ( select min(firstdelivery) from abc.items WHERE I.polizzennummer = polizzennummer )…