PHP 因 mySQL 错误而停止，但 INSERT 已记录到数据库中

Question

正如标题所示，我收到两个错误，并且插入已被记录/接受。这是 mySQL:

$anvSQL = "
    INSERT INTO members (login, date) 
    VALUES('GRFU25F9J8P5P3rYIDUP', '2014-11-11 09:59:56')
";

if (!mysqli_query($con, $anvSQL))           
{
    die('Error: ' . mysqli_error($con));
}       
else
{
    echo "<br>1 record added";
}

字段登录是文本，日期是日期时间格式。这是完整的错误消息:

1 record added 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 ' '2014-11-11 09:59:56')' at line 1

Answer 1

我完全使用了你的架构并且它有效(MySQL 服务器版本:5.5.40)

mysql> create table members(login text, date datetime);
Query OK, 0 rows affected (0.40 sec)

mysql> INSERT INTO members (login, date) 
    ->     VALUES('GRFU25F9J8P5P3rYIDUP', '2014-11-11 09:59:56');
Query OK, 1 row affected (0.28 sec)

即使official documentation关于日期的说明:

MySQL permits some keywords to be used as unquoted identifiers because many people previously used them.

重命名您的列名称很有用，正如此 question. 的答案中提到的那样