mysql表,生成行的序号列,类似oracle的rownum
程序员文章站
2022-06-24 08:39:37
...
SELECT @rownum:=@rownum+1 id, FK_RECORD_ID, NAME NAME_ATTR, VALUE VALUE_ATTR FROM (SELECT @rownum:=0, FK_RECORD_ID, NAME, VALUE FROM documentsText1 ORDER BY NAME) t
下一篇: 详解vue中组件参数