yzmFBQdd1407191(提问者) 回复 15922204585我那个日月周要一起查出来,可是我这样写报错
SELECT
$ {
IF (
Query_type = \"DAY\",
DATE_FORMAT(CREATE_TIME, \'%Y-%m-%d\') AS DAY
),
IF (
Query_type = \"WEEK\",
DATE_FORMAT(CREATE_TIME, \'%Y-%u\') AS WEEK
),
IF (
Query_type = \"MONTH\",
DATE_FORMAT(CREATE_TIME, \'%Y-%m\') AS MONTH
) }
FROM
rma_data
WHERE