CODEWITHSUNDEEP
mysqlmysql-workbench
enzio902
enzio902

Reputation: 467

MySQL Syntax error : "<table_name> is not valid at this position, expecting the name of an existing table". Table already exists

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

enter image description here

groups table exists in the selected database as shown above.

Upvotes: 3

Views: 4090

Answers (1)

Sebastian Brosch
Sebastian Brosch

Reputation: 43574

GROUPS is a reserved word since MySQL 8.0.2. In this case you have to escape the table name with backticks. So you have to use the following INSERT INTO command:

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

Upvotes: 6

Related Questions