Good Syntax Getting Syntax Error #1064 from PHPMyAdmin

Question

I am getting this error:

#1064 - You have an error in your SQL syntax....near 'Group) 
VALUES ('$username', '$password', '$email', '$group')' at line 1

With this code:

INSERT INTO T2T_Main.users (Username, Password, EmailAddress, Group) 
VALUES ('$username', '$password', '$email', '$group')

But I cannot figure out what the problem is. It looks fine to me!

Answer 1

Change column name Group because it is a function or key word used in mysql syntax.