SELECT @rowNum:=@rowNum+1 no, video.* FROM Video JOIN (SELECT @rowNum:= 0)as r;
no序列从1开始。
#SELECT video.*,
@rowNum:=@rowNum+1 no FROM Video JOIN (SELECT @rowNum:= 0)as r;
两种查询,显示结果略有不同哦~~
SELECT @rowNum:=@rowNum+1 no, video.* FROM Video JOIN (SELECT @rowNum:= 0)as r;
no序列从1开始。
#SELECT video.*,
@rowNum:=@rowNum+1 no FROM Video JOIN (SELECT @rowNum:= 0)as r;
两种查询,显示结果略有不同哦~~