p.patientID = ap.patientID where d.status = 1 and DATE_FORMAT(ap.appDate, '%Y-%m') = '2013where d.status = 1 and DATE_FORMAT(ap.appDate, '%Y-%m') = '2013-10'#1064 - You have an error inthe right syntax to use near '
month_visited是一个CHAR(7)列,如下所示:'2013-10‘DELETE FROM visits WHERE month_visited = '2013-10'但这需要很长时间。当我试着
EXPLAIN SELECT * FROM visits WHERE month_visited = "