update bak_player_uploads inner join bakplayers on bak_player_uploads.player_id=bakplayers.id set bak_player_uploads.ClubShirtNo=bakplayers.ShirtNo
注解:在mysql中update不支持where后面的select语句,所以需要使用内连接来实现。
![]() |
|
update bak_player_uploads inner join bakplayers on bak_player_uploads.player_id=bakplayers.id set bak_player_uploads.ClubShirtNo=bakplayers.ShirtNo
注解:在mysql中update不支持where后面的select语句,所以需要使用内连接来实现。
|
|
|