mysql添加行數(shù)快捷鍵?
mysql : Select a.*,(@rowNum:=@rowNum+1) as rowNo From a, (Select (@rowNum :=0) ) b oracle : select a.*,rownum from a sql server : select row_number()over(order by XX)as RowNum,* from a
mysql添加行數(shù)快捷鍵?
mysql : Select a.*,(@rowNum:=@rowNum+1) as rowNo From a, (Select (@rowNum :=0) ) b oracle : select a.*,rownum from a sql server : select row_number()over(order by XX)as RowNum,* from a