mindoc

ODBC

DRIVER=Devart ODBC Driver for SQLite;Description=mindoc;Database=D:\mindoc.db

SELECT attachment_id AS 文件ID,file_name AS 文件名, ‘http://124.71.33.56:3000' || file_path AS 下载地址 FROM [main].[md_attachment] WHERE file_ext = ‘.mp4’ ORDER BY attachment_id DESC