I am new to Mysql. I have a stored procedure,below is my SP

CREATE DEFINER=`root`@`localhost` PROCEDURE `insertGroup`(IN startdate date, 
IN  enddate date, 
 IN  amount int, 
IN  groupname char(50))
BEGIN

DECLARE c_id INT; 

set c_id  =(select  id from c_begin where startdate = startdate and enddate = enddate and amount = amount);


insert into c_group (c_beginid,Groupname) 
select * from (select c_id,groupname) as temp 
where not exists (
select c_beginid,groupname from c_group where c_beginid = c_id and groupname = groupname 
) ;


END

I am calling it like

call insertGroup ('2014-01-01','2015-12-31',100000,'GroupD');

But it is not inserting any row. I am trying to insert into "c_group" if the c_beginid and groupname is not exists.

But when i try like below

insert into c_group (c_beginid,Groupname) 
select * from (select 1,'GroupD') as temp 
where not exists (
select c_beginid,groupname from c_group where c_beginid = 1 and groupname = 'GroupD' 
) limit 1 ;

it is working.

So What went wrong in my "insertGroup" SP. Can any one help me ?

Thanks ,