lundi 25 mai 2015

Multi-valued INSERT for SQLite3 using PDO

I am currently trying to use the multi-valued INSERT queries with SQLite3 and PDO.

I did some research and found that before SQLite version: 3.7.11 the multi-valued INSERT syntax was not supported. This has since (2012) changed.

My phpinfo() is informing me that:

PDO Driver for SQLite 3.x   enabled
SQLite Library  3.7.7.1

Regardless of that, PDO doesn't seem to support using these kinds of INSERT queries using SQLite3.

My question is if there is any workaround this issue. I am working on an application that is compatible with both SQLite3 and MySQL. Seeing that both of them support multi-value inserts, I would hate to use two kinds of query and INSERT logic only because PDO is not up-to-date.

Aucun commentaire:

Enregistrer un commentaire