Visual-JOIN icon indicating copy to clipboard operation
Visual-JOIN copied to clipboard

Published 20 hours ago • verified publisher icon spathon

Correction in SQL Query ?

Open isabytes opened this issue 1 year ago • 1 comments

It appears that the provided SQL Query might cause a misunderstanding due to the use of the "likes.like" without proper escaping or aliasing. You may want to use backticks or double quotes around the column name "like" in the SELECT statement since it is a reserved keyword in SQL

image

isabytes avatar Jan 20 '24 16:01 isabytes

It works in MySQL without when the table name is prefixed but you are welcome to create a pull request with backticks

likes.`like`

spathon avatar Jan 23 '24 09:01 spathon