各种数据库的临时编号的形成（Index）
Mysql
SET @row_number = 0;
SELECT (@row_number := @row_number + 1) AS row_number, column1, column2
FROM table_name;
如果出现错误信息：
InnerException = {“Parameter ‘@row_number’ must be defined.”}
则需要再url连接字符上加上一个参数（打开用户的自定义变量的使用）：
allowuservariables=True
server=myServerAddress;user=myUsername;password=myPassword;database=myDatabase;allowuservariables=True;
SQLserver
select * from (
SELECT ROW_NUMBER() OVER (ORDER BY 单号) AS rowno,* FROM(
表名或查询语句
) as a
where 1=1 KaTeX parse error: Expected '}', got 'EOF' at end of input: …no between 20*({page}-1)+1 and 20*${page}
原文地址：https://blog.csdn.net/weixin_40029679/article/details/142753729
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！