search

catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.83k stars 1.15k forks source link

Error near "," when multiple insert in sqlite db #533

Closed Drive4ik closed 7 years ago

Drive4ik commented 7 years ago

Error near "," when multiple insert in sqlite db. sqlite 3.7.7.1 php 5.3.27 Medoo 1.2.1

Drive4ik commented 7 years ago

Can you investigate this issue?

catfan commented 7 years ago

Perhaps you need to update your SQLite to 3.7.11+ for multiple insertion.

Because v1.2 is optimized the multiple insertion statement with executing only one query INSERT INTO xxx VALUES(xxx), (xxx), (xxx), which is supported since SQL 3.7.11+.

http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database/1609688#1609688