怎样为mysql视图增加一列标识ID
我有视图如下
CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `view2` AS
SELECT SQL_NO_CACHE
`sub`.`team_no` AS `team_no`,
`sub`.`id` AS `id`,
`sub`.`university_no` AS `university_no`,
`sub`.`team_name` AS `team_name`,
`sub`.`teacher` AS `teacher`,
`sub`.`teacher_phone` AS `teacher_phone`,
`sub`.`works_name` AS `works_name`,
`sub`.`types` AS `types`,
`sub`.`description` AS `description`
FROM
`view1` `sub`
GROUP BY `sub`.`id`
想增加一列 id从1开始依次增加