SET @mycnt=0;
SELECT @mycnt := @mycnt +1 as mycnt, a.*, b.*
FROM a, b;
表中第一列即为mycnt,从1开始计数。
SET @mycnt=0;
SELECT @mycnt := @mycnt +1 as mycnt, a.*, b.*
FROM a, b;
表中第一列即为mycnt,从1开始计数。
转载于:https://www.cnblogs.com/CSGrandeur/archive/2012/11/30/2796382.html