MySQL, Why Does This Simple 'CREATE TABLE' Query Fail?

Question

A very simple query.

CREATE TABLE Group
(
    Group_ID int NOT NULL PRIMARY KEY,
    Group_Name varchar(128)
);

Unfortunately, it will not execute, see error below in PhpMyAdmin. Screenshot

I have checked and checked again, it seems to be syntactically correct, but never will complete.

Answer 1

Group is a reserved keyword to use it as table name you need to escape it.

Use Back-ticks to escape the reserved Keywords

CREATE TABLE `Group`
(
    Group_ID int NOT NULL PRIMARY KEY,
    Group_Name varchar(128)
);