sql语句语法错误，求指教

[神的理想]

insert into ut_mail (playerid, sendname, title, content, items, sendtime, readit) values('.$playerid.', "sysmail", "test", "test", "test", "test", "test") select distinct playerid from ut_player

[神的理想]

缩短了

insert into ut_mail (playerid, sendname, title) values('".$playerid."', "sysmail", "test") select distinct playerid from ut_player

[WWWWA]

insert into ut_mail (playerid, sendname, title) values('".$playerid."', "sysmail", "test") select distinct playerid from ut_player 你要达到什么目的？SQL语句语法错误

[神的理想]

引用 2 楼 WWWWA 的回复:

insert into ut_mail (playerid, sendname, title) values('".$playerid."', "sysmail", "test") select distinct playerid from ut_player 你要达到什么目的？SQL语句语法错误

就是查询到多少个playerid就插入多少条记录到ut_mail表中

[WWWWA]

insert into ut_mail (playerid, sendname, title) select distinct playerid ,"sysmail", "test" from ut_player

[神的理想]

引用 4 楼 WWWWA 的回复:

insert into ut_mail (playerid, sendname, title) select distinct playerid ,"sysmail", "test" from ut_player

ut_player 表里只有 playerid 测试还是不行

[WWWWA]

提示什么？语法？

[神的理想]

引用 6 楼 WWWWA 的回复:

提示什么？语法？

刚测试对了，这样没错！ insert into ut_mail (playerid, sendname, title) select distinct playerid ,"sysmail", "test" from ut_player