整个查询可以在MySQL客户端中使用文字,但在从PHP中传递时就会崩溃。在PHP中,如果每个查询单独提交,则每个查询都有效,但如果在START和COMMIT中提交,则不起作用。to use near 'INSERT INTO user_degrees (user_id, degree_id, acadcat_id查询:
INSERT INT
当我手动检查phpmyadmin时,我的sql查询运行良好,但当我尝试通过php mysql_query处理它时,会抛出一个语法错误。如何解决这个问题?MySQL server version for the right syntax to use near 'INSERT INTO scores( user_id ) VALUES (LAST_INSERT_ID"INSERT INTO scores( user_id ) VALUES (LAST_INSERT_ID( ));";