填报插入数据时自动生成流水号- FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)
这个怎么修改成mysql的语句
CONCATENATE("ABC", format(today(), "yyyyMMdd"), format(sql("sqlserver", "SELECT max(right(id,4)*1) maxid FROM [dbo].[流水号] where substring(id,4,8)=DATE_FORMAT(NOW(),'%Y-%m-%d')", 1, 1) * 1 + 1, "0000"))
CONCATENATE("ABC", format(today(), "yyyyMMdd"), format(sql("mysql数据库名", "SELECT max(right(id,4)*1) maxid FROM [dbo].[流水号] where SUBSTRING(id,4,8)=DATE_FORMAT(CURDATE() ,'%Y%m%d')", 1, 1) * 1 + 1, "0000"))