sql批量修改某一字段为另一张表字段 随机不对应
update mg_c set mg_c.majorID = (select majorID from major where length(majorID) > 4 order by rand() limit 1)
sql批量修改某一字段为另一张表字段 随机不对应
update mg_c set mg_c.majorID = (select majorID from major where length(majorID) > 4 order by rand() limit 1)