Solved deleting deep list

[cheatchki]

So this is example code, its not actual code i am using but very very similar code, basically with just different variable names

but now I want to erase everything from {x::*}
I tried

set {x::y::1} to true
set {x::y::2} to true
set {x::z::1} to false
set {x::z::2} to true

delete {x::*}

then

set {x::y::1} to true
set {x::y::2} to true
set {x::z::1} to false
set {x::z::2} to true

loop {x::*}:
    delete {x::%loop-index%}

however none of these worked and after some testing I did manage to get something like

set {x::y} to true
set {x::y::1} to true
set {x::y::2} to true
set {x::z} to true
set {x::z::1} to false
set {x::z::2} to true

loop {x::*}:
    loop {x::%loop-index%::*}:
        delete {x::%loop-index-1%::%loop-index-2}
    delete {x::%loop-index-1%}

And this worked however this seemed horridly ineffecient, and I would prefer to be able to just delete it all at once, but all the methods except the last one seemed to fail. Anyone else other suggestions?

side note: not sure if it fully matters however I am using a MySQL and i have tried on a SQlite, however i have not tried on the csv format
[doublepost=1500895731,1500893140][/doublepost]Nvm I pulled a dumb and realized the variable names were just slightly off on my first attempts!