SQL Error:
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 'AND alb_show = 'Y' ORDER BY year DESC LIMIT 11' at line 1
SELECT DISTINCT YEAR(alb_dt) as year
FROM album
WHERE alb_ac_id = AND alb_show = 'Y'
ORDER BY year DESC
LIMIT 11
SQL Error:
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 'AND alb_show = 'Y' ORDER BY month ASC' at line 1
SELECT DISTINCT MONTH(alb_dt) as month
FROM album
WHERE alb_ac_id = AND alb_show = 'Y'
ORDER BY month ASC
學生表現