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
mysql表,生成行的序号列,类似oracle的rownum
最新推荐文章于 2024-04-01 21:34:28 发布
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