sql 定义自增id插入数据

-- 定义一个自增变量
set @i=0;
-- 执行自增语句
    Select @i:=@i+1,sponsorbroker,'01',1000,'2014-12-31',0,0  
    from stock_listing_detailed_info group by sponsorbroker;

 

转载于:https://www.cnblogs.com/hwaggLee/p/4566885.html