mysql的自增列

CREATE TABLE `tb_one_user_role` (
  `id` INT(50) NOT NULL AUTO_INCREMENT COMMENT ‘主键id‘,
  `user_id` VARCHAR(50) NOT NULL COMMENT ‘苹果手机唯一标识‘,
  `role` VARCHAR(255) DEFAULT NULL COMMENT ‘角色（获取一级权限时用）‘,
  `input_date` DATE DEFAULT NULL,
  PRIMARY KEY (`id`)
  ;

SET @end1=(SELECT 0 FROM DUAL);
SELECT (@end1:=@end1+1) AS id,a.* FROM tb_user a;