SQLITE 表达式 技术教程文章

PDO SQLite无法绑定NOT IN表达式【代码】

这是代码:<?php $dbh = new \PDO('sqlite:'); $dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );$goodSql = 'SELECT number FROM (SELECT 1 number UNION SELECT 2) numbers WHERE number not in (2)'; echo json_encode($dbh->query($goodSql)->fetchAll(PDO::FETCH_NUM));$badSql = 'SELECT number FROM (SELECT 1 number UNION SELECT 2) numbers WHERE number not in (?)'; $binds = ['2']; $statement = $d...