php - ZF2中的SQL查询语法错误

Question

我在我的应用程序中使用 zend Framework 2。我想简单地执行这个查询...

$sql = "INSERT INTO tbl_group(group_name, group_order, version_id_fk, group_code)
                            SELECT group_name, group_order, {$newVersionId}, $this->getServiceLocator()->get('commonService')->randomMD5() FROM tbl_group
                            WHERE version_id_fk = {$versionArray['version_id_pk']}";

但我收到此错误:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')->get('commonService')->randomMD5() FROM tbl_group WHERE version_id_fk ' at line 2

谁能建议我如何解决这个问题？

谢谢!

Answer 1

句号(.)是PHP中的连接运算符，您正在编写SQL。

应该是CURRENT_TIMESTAMP + RAND()

不选择CURRENT_TIMESTAMP。兰德()