Ergebnis der Suchanfrage

• Forum: Datenbanken

  AW: verschachtelte Query

   
    by himitsu, 21. Apr 2020
  https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query
  
  with recursive temptablename (id, name, parent_id) as (
  select id, name, parent_id
  from products
  where parent_id = 19 -- Initialisierung
  
  union all
  select p.id, p.name, p.parent_id
  from products p