This topic created in 4005 days ago, the information mentioned may be changed or developed.
随机取某表一条数据并更改某个字段值然后新增修改过的这条数据
4 replies • 2015-11-29 13:52:38 +08:00
 |
|
kchumNov 28, 2015 via iPhone
1
Update 和 Insert 为什么不分开?
|
 |
|
楼上+1
|
 |
|
insert into 表 (a, b, c, d, e, f) select a, b, c, '新数据', e, f from 表 where 随机取一条
|