Tag: sql
- [PHP/Codeigniter] Getting multi-queries right with SQLITE (14 Nov 2022)
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...
- [PHP/Codeigniter] Playing with multi-queries in MySQL (12 Oct 2022)
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...