is not valid at this position, expecting the name of an existing table". 表已存在-6ren"> is not valid at this position, expecting the name of an existing table". 表已存在-MySQL 版本:mysql Ver 8.0.11 for macos10.13 on x86_64 (MySQL Community Server - GPL) groups 表存在于所选数据库中,-6ren">
gpt4 book ai didi

MySQL 语法错误 : " is not valid at this position, expecting the name of an existing table". 表已存在

转载 作者:行者123 更新时间:2023-11-29 01:26:01 25 4
gpt4 key购买 nike

MySQL 版本:mysql Ver 8.0.11 for macos10.13 on x86_64 (MySQL Community Server - GPL)

enter image description here

groups 表存在于所选数据库中,如上所示。

最佳答案

GROUPS 是一个 reserved word从 MySQL 8.0.2 开始。在这种情况下,您必须使用反引号转义表名。因此,您必须使用以下 INSERT INTO 命令:

INSERT INTO `groups` (column_name) VALUES (column_value)

关于MySQL 语法错误 : "<table_name> is not valid at this position, expecting the name of an existing table". 表已存在,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/54286989/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com