Error while executing MySQL queries on MySQL server version 8

Question

I am trying to execute a query on MySQL server but it is throwing below errors. It was working fine on MySQL server 5.1 but now I am using 8.0

Query

SELECT group1s.group_id, group1s.customer_id
 FROM icm_b_instance_group1s as group1s inner join icm_b_instance_groups 
as groups on group1s.group_id = groups.group_id
 where group1s.is_active = 'Y' and groups.is_active = 'Y';

[Code: 1064, SQL State: 42000] 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 'groups on group1s.group_id = groups.group_id' at line 2

forpas · Accepted Answer · 2019-07-18 13:02:07Z

1

From MySQL 8.0 Keywords and Reserved Words

GROUPS (R); added in 8.0.2 (reserved)

So groups which you use as an alias is a reserved word and cannot be used in versions 8.0.2+

answered Jul 18, 2019 at 13:02

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Madhur Bhaiya Over a year ago

It can be used, if you use backticks around it. Although it is better to rename alias to something else.

forpas Over a year ago

Reserved words should not be used in any case to avoid such errors and confusion. The problem is with the new reserved words that each new version may add. So renaming all old uses is the best option.

Asghar Nazir Over a year ago

Thank you very much @forpas

Collectives™ on Stack Overflow

Error while executing MySQL queries on MySQL server version 8

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related