How to execute multiple queries in MySQL using CodeIgniter

from blog Prahlad Yeri, | ↗ original
Multi-queries are often discouraged with mysqli functions but there are times when you must use them. One obvious use case is initializing the database. One of the first things your app must do is determine if the database tables exist or not, and then run an initializing SQL script if they don’t. This script may include multiple queries for...