SQLite Forum

can we use a for/while loop inside sqlite triggers ?
Login
I don't understand why you need trigger recursion for this.  It is possible to delete all the rows you want to delete in one command.  There's no need to do it one by one.