mysql

mysql_sql.sql

-- mysql单条SQL查询出分页和总数

  SELECT SQL_CALC_FOUND_ROWS t.* FROM ( SELECT 1 AS allCount,
   dr.id AS reportId
  FROM dr_daily dr
  WHERE 1=1
  GROUP BY dr.id
  ORDER BY dr.create_time DESC
  )t
  LIMIT 1,2 
  UNION ALL SELECT FOUND_ROWS() AS allCount, NULL


-- 假设要按照用户表 user 用户名 Username 的拼音排序
SELECT * FROM user ORDER BY CONVERT(Username USING gbk) COLLATE gbk_chinese_ci DESC;