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