我有一个问题与 mysql条件注释查询,其中错误报告没有语法错误.在这种情况下,至少有一个查询实际上是用条件执行的.

我正在使用PHP 5.6.24和MysqL 5.5.52-cll

示例1(成功)：

<?PHP
$conn = MysqLi_connect("127.0.0.1","aaatex_PHPpos","PHPpos","aaatex_PHPpos2");

$test1 = "
/*!40000 REPLACE INTO `PHPpos_app_config` (`key`,`value`) VALUES ('supports_full_text','0') */;
/*!50604 REPLACE INTO `PHPpos_app_config` (`key`,'1') */;";

MysqLi_multi_query($conn,$test1);
PRint_r(MysqLi_error_list($conn));
?>

supports_full_text的值为0.

示例2(失败)：

<?PHP
$conn = MysqLi_connect("127.0.0.1","aaatex_PHPpos2");

$test2 = "
/*!50604 REPLACE INTO `PHPpos_app_config` (`key`,`value`) VALUES ('test',$test2);
print_r(MysqLi_error_list($conn));

错误收到：

Array
(
    [0] => Array
        (
            [errno] => 1064
            [sqlstate] => 42000
            [error] => You have an error in your sql Syntax; check the manual that corresponds to your MysqL server version for the right Syntax to use near ';
    /*!50604 REPLACE INTO `PHPpos_app_config` (`key`,'1' at line 1
        )

)

示例3(失败;但看起来像成功(见下面的消息)：

<?PHP
$conn = MysqLi_connect("127.0.0.1","aaatex_PHPpos2");

$test3 = "
/*!40000 REPLACE INTO `PHPpos_app_config` (`key`,$test3);
print_r(MysqLi_error_list($conn));

测试值为0.

这是PHP中的错误还是我做错了？

编辑：

注意：我发现当查询失败时,STOPS处理文件的其余部分.所以例3在第2和第3查询中仍然有错误;我没有抓到所有的错误. 40000查询工作;但任何不运行当前的MysqL版本失败作为语法错误.

You have an error in your sql Syntax; check the manual that corresponds to your MysqL server version for the right Syntax to use near ';
    /*!50604 REPLACE INTO `PHPpos_app_config` (`key`,'1' at line 1