$queryStatus = mysql_query("INSERT into `database`.`users` (`first`, `last`, `pass`, `user`, `id`, `email`, `active`) VALUES ('$first', '$last', '$password', '$user', NULL, '$email', '0'") or die("BAD QUERY: " . mysql_error());
ID字段为NULL,因为它是自动增量.但它抛出了语法错误,我真的无法找出原因.请帮忙.
解决方法:
忽略ID字段,它将自动插入值:
$queryStatus = mysql_query("INSERT into `database`.`users` (`first`, `last`, `pass`, `user`, `email`, `active`) VALUES ('$first', '$last', '$password', '$user', '$email', '0'") or die("BAD QUERY: " . mysql_error());
你的查询似乎也很糟糕(错误地将引号放在最后),我不确定PHP具体但这应该工作:
$queryStatus = mysql_query("INSERT into `database`.`users` (`first`, `last`, `pass`, `user`, `email`, `active`) VALUES ('$first', '$last', '$password', '$user', '$email', '0')");
标签:php,mysql,syntax-error
来源: https://codeday.me/bug/20190827/1735648.html