摘要:
select *,(CASE WHEN ((SELECT now()) BETWEEN start_time and end_time) THEN '中间' when ((SELECT now()) < start_time) then '之前' ELSE '结束' END) as paper_st 阅读全文
摘要:
SELECT cast(@rank := @rank+1 as char) as rowNum,a.* from (select oup.user_name as userName,oup.user_id as userId,oup.student_sex as studentSex,op.Intr 阅读全文