MYSQL, not valid at this position, expecting an identifier

I am struggling my head around days to get rid of this error, but still in vain.
I already search SO before posting the error, but none of them helped me.
Snapshot

Picture with error message

Here is my query

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE groups;

SET FOREIGN_KEY_CHECKS = 1;

I double checked the the table group exist

Edit: Just found out that groups is a reserved keyword in MySQL, so is there anyway for me to truncate the table groups

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

As written in the edit, that groups is a reserved word in MySQL, so I had to use the syntax like this

TRUNCATE `groups`

in order to make it work.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating