How to handle multiple queries in SQLite using CodeIgniter

from blog Prahlad Yeri, | ↗ original
My earlier article dealt with multi-query issues of MySQL, this one is dedicated to SQLITE. Multi-queries are often discouraged to begin with but there are times when you find yourself using them. One typical use case is populating the database initially when it’s empty. You do this by running an SQL script which may include multiple queries for...