mysql表,生成行的序号列,类似oracle的rownum
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_mysql》,跪求各位点评,by 搞代码