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;…..
