随机取某表一条数据并更改某个字段值然后新增修改过的这条数据
This topic created in 3825 days ago, the information mentioned may be changed or developed.
 |
1
kchum Nov 28, 2015 via iPhone
Update 和 Insert 为什么不分开？
|
 |
2
xuhaoyangx Nov 28, 2015
楼上+1
|
 |
3
msg7086 Nov 29, 2015
insert into 表 (a, b, c, d, e, f)
select a, b, c, '新数据', e, f from 表 where 随机取一条 |
Select Language