mysql 如何实现insert与select 联合使用？请给个例子，多谢

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