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.
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
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.
As written in the edit, that
groups is a reserved word in MySQL, so I had to use the syntax like this
in order to make it work.