mysql 怎么实现insert与select 联合使用？请给个例子，谢谢！
insert into role_info(ID,rolename)
value (select (max(id)+1) as maxid from role_info, 'ddddd ');

[解决办法]
insert into role_info select (max(id)+1) as maxid, 'ddddd ' from role_info;

[解决办法]
maybe不行
[解决办法]
和SQL SERVER一样
insert into table1 select 1,2;.....