1、增
1.1、插入序号列:
row_number 是一个排名函数,从第一行开始
-> SET @row_number = 0; //将row_number初始化
-> SELECT (@row_number := @row_number + 1) AS num,
-> 客户ID,主订单ID
-> FROM
-> custorder; //可在最后加上limit ,限制行数
运算结果:
1、增
1.1、插入序号列:
row_number 是一个排名函数,从第一行开始
-> SET @row_number = 0; //将row_number初始化
-> SELECT (@row_number := @row_number + 1) AS num,
-> 客户ID,主订单ID
-> FROM
-> custorder; //可在最后加上limit ,限制行数
运算结果: