缩短了
insert into ut_mail (playerid, sendname, title) values('".$playerid."', "sysmail", "test") select distinct playerid from ut_player
insert into ut_mail (playerid, sendname, title) values('".$playerid."', "sysmail", "test") select distinct playerid from ut_player
就是查询到多少个playerid就插入多少条记录到ut_mail表中
select distinct playerid ,"sysmail", "test" from ut_player
insert into ut_mail (playerid, sendname, title)
select distinct playerid ,"sysmail", "test" from ut_player