用mysql...
id name
1 zhttty
2 Koo
3 zhttty
如上表更新成下表：
id name
1 zhttty1
2 Koo
3 zhttty3
sql怎么写？一同事问的，让我百思不得其解...
id name
1 zhttty
2 Koo
3 zhttty
如上表更新成下表：
id name
1 zhttty1
2 Koo
3 zhttty3
sql怎么写？一同事问的，让我百思不得其解...
This topic created in 4864 days ago, the information mentioned may be changed or developed.
 |
1
update tb set name = name + cast(id as varchar(10)) where name in (
select name from tb group by name having count(*) > 1 ) |
1 |
2
@lichao 你的有误的，不能同时查出表又同时修改表...
You can't specify target table 'test' for update in FROM clause 不过还是提供了些思路。 |
 |
66betaJul 10, 2013
4
视图可以吗？
|
 |
keakonJul 10, 2013
5
你的需求有问题吧
如果是这样的： id name 1 a 2 a1 3 a12 你要怎么改名？ |
|
6
|
Select Language