-
Incident report
-
Resolution: Duplicate
-
Blocker
-
None
-
3.4.12
-
None
-
None
when i in mysql8 use zabbix database
desc groups
mysql> use zabbix
Database changed
mysql> desc groups;
ERROR 1064 (42000): 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 'groups' at line 1
mysql> desc zabbix.groups;
------------------------------------------------+
Field | Type | Null | Key | Default | Extra |
------------------------------------------------+
groupid | bigint(20) unsigned | NO | PRI | NULL | |
name | varchar(255) | NO | MUL | ||
internal | int(11) | NO | 0 | ||
flags | int(11) | NO | 0 |
------------------------------------------------+
4 rows in set (0.00 sec)
i feel 'groups' is key word in mysql8
how can i resolve this problem?
- is duplicated by
-
ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0
-
- Closed
-