mysql 查找结果中自动加一列序号列ID

分类: 文章 • 2024-05-17 14:40:22

select (@rowNO := @rowNo+1) AS id,titleName
,pContent,date_format(createDate,'%Y-%m-%d') createDate,detailed
from(select cn.titleName,cn.pContent,cn.createDate,nd.detailed from stock_cctv_news cn ,stock_cctv_news_detailed nd
where cn.createDate=nd.createDate )a,(select @rowNO :=0) b