查询结果表格不是按指定的字段先后顺序显示

[entps]

[Zuoqiu-Yingyi]

在字段别名首添加 __<数字>__ 即可定义查询结果顺序, 如下所示

SELECT
  content as __01__文件名,
  hpath as __02__笔记本,
  created as __03__创建日期,
  updated as __04__更新日期
FROM
  blocks
WHERE
  type = 'd';