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.

`Group` is a reserved word. Either choose a different name or use backticks... — sgeddes, Mar 04 '16 at 18:36

score 0 · Accepted Answer · answered Mar 04 '16 at 18:38

0

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)
);

answered Mar 04 '16 at 18:38

Pரதீப்

1 Answers1