人大金仓报错CONNECT BY clause required in this query block
原因是有关键字level,附数据库关键字,比较多
解决方案 要么替换掉level;要么用别名;要么`(反单引号)替换成"(双引号)
PDOStatement Object
(
[queryString] => SELECT id, parent_id, level, lft, rgt
FROM a3bav_menu
WHERE id = 1 LIMIT 1
)
SQLSTATE[42601]: Syntax error: 7 ERROR: CONNECT BY clause required in this query block LINE 1: SELECT id, parent_id, level, lft, rgt ^stop pdo.php
alter system set exclude_reserved_words='level';
评论 (0)