How to choose a table that has the table name : "group"?

Question

I have a table. Name of the table is "group"

I run query like this:

SELECT * FROM GROUP

There exist error like this:

Error Code: 1064
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 'group 
 LIMIT 0, 1000' at line 1

Any solution to solve my problem?

sonique · Accepted Answer · 2016-05-25T04:27:34.430

11

use backquote :

SELECT * FROM `GROUP`

you can also alias your table name for later use in WHERE clause for instance:

SELECT * FROM `GROUP` g WHERE g.id = 1

edited May 25 '16 at 04:27

answered May 25 '16 at 04:13

sonique

4,539
2
30
39

6

Or stop using [**RESERVED WORDS**](http://dev.mysql.com/doc/refman/5.7/en/keywords.html) as table names – Juan Carlos Oropeza May 25 '16 at 04:15
@Juan Carlos Oropeza, Why? I using reserved words and it's no problem – moses toh May 25 '16 at 04:59
I think avoid using a reserved word is a good practice, but not impossible. – Claudio Aug 31 '21 at 22:37

How to choose a table that has the table name : "group"?

1 Answers1