Timeline for How can I handle cycles / infinite loops in recursive CTEs in MySQL
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 30, 2022 at 12:54 | comment | added | Akina | @dakini CONCAT_WS acts similarly CONCAT. But it if NULL-safe - it simply ignores NULLs whereas CONCAT returns NULL if at least one operand is NULL. | |
| Nov 30, 2022 at 12:50 | vote | accept | ahron | ||
| Nov 30, 2022 at 12:50 | comment | added | ahron |
Okay! Thank you so much! It is a very "involved" approach with concat_ws.
|
|
| Nov 30, 2022 at 11:49 | comment | added | Akina | @dakini dbfiddle.uk/OAC1BWlX | |
| Nov 30, 2022 at 11:17 | comment | added | ahron |
Thanks! Could you please show instead how to use FIND_IN_SET as you had mentioned in your comment to the question.
|
|
| Nov 30, 2022 at 11:10 | history | answered | Akina | CC BY-SA 4.0 |