id (自动增长) type name number
1 2 2 1
2 3 3 1
3 21 21 1
现在要实现
id (自动增长) type name number
1 2 2 1
2 3 3 1
3 21 21 1
4 2 2 2
5 3 3 2
6 21 21 2怎么实现
1 2 2 1
2 3 3 1
3 21 21 1
现在要实现
id (自动增长) type name number
1 2 2 1
2 3 3 1
3 21 21 1
4 2 2 2
5 3 3 2
6 21 21 2怎么实现
select * from proginfo where progname in
( Select progname from proginfo group by progname having count(*)=1)
我想把这些值在原来的数据库中在写一边 并且修改NUM=2(原来是1)
select type,name,number+1 as number from table