select shoppingmall_classify.*, @rownum:[email protected]+1 rownum from (select @rownum:=0) r, shoppingmall_classify
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL6tmaNNTUE5UeRpHW4Z0MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnLyIjN2QDMwQTMxMTNwkTMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
結束語:如果有寫的不好或者不太懂得地方可以在下方評論
select shoppingmall_classify.*, @rownum:[email protected]+1 rownum from (select @rownum:=0) r, shoppingmall_classify
結束語:如果有寫的不好或者不太懂得地方可以在下方評論