Search code examples
sqliteloopsfor-loopwhile-loopprocedural

SQLite Flow Constructs in SQL?

With MSSQL, I can mix in case, if...then, and while constructs in my SQL code. Is anything similar available for SQLite? I have not seen anything on "mixing procedurally" with SQLite, anywhere.

Thanks.

Solution

  • SQLite doesn't have any loop syntax - FOR or WHILE. CASE statements are supported rather than IF.