current position:Home>MySQL reports an error in Navicat. How to solve it?

MySQL reports an error in Navicat. How to solve it?

2022-02-03 00:18:39 CSDN Q & A

This is a watch , There are also errors. Please ask experts for help , Solve this problem .

1064 - 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 'SUM(CASE course.coursename WHEN " database "THEN score.scorecj ELSE 0 END)AS" Count ' at line 4

img

img

img

img




Refer to the answer 1:

As There should be a space between the following aliases ,As Add a space before it .




Refer to the answer 2:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.
https://en.primo.wiki/2022/02/202202030018366562.html

Random recommended