algorithm icon indicating copy to clipboard operation
algorithm copied to clipboard

RUNTIME ERROR !! - Article Views I

Open dangesid opened this issue 1 year ago • 1 comments

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 'select distinct author_id as id from Views where author_id = viewer_id order by ' at line 13

dangesid avatar Jun 18 '24 10:06 dangesid

The solution worked for me ...!!

SELECT DISTINCT author_id AS id FROM Views WHERE author_id = viewer_id ORDER BY author_id ASC;

dangesid avatar Jun 18 '24 10:06 dangesid