MySQL查询结果条数编号示例 mysql 查找结果中自动加序号列
SELECT @row := @row + 1 as row, t.id FROM sgcorp_product t, (SELECT @row := 0) r where t.id not in(select product_id from sgcorp_pic)
posted on 2013-03-07 13:13 passer1991 阅读(394) 评论(0) 编辑 收藏 举报
SELECT @row := @row + 1 as row, t.id FROM sgcorp_product t, (SELECT @row := 0) r where t.id not in(select product_id from sgcorp_pic)
posted on 2013-03-07 13:13 passer1991 阅读(394) 评论(0) 编辑 收藏 举报