DELIMITER $$

DROP PROCEDURE IF EXISTS `Sp_UserProfile` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Userdata`(Fname varchar(50),LName varchar(45),Collg varchar(30),course varchar(30))

BEGIN

declare uaccid int;
declare memid int;
declare cnt1 int default 0;
declare cnt2 int default 0;

DECLARE EXIT HANDLER FOR SQLEXCEPTION rollback;
declare exit handler for not found rollback;
declare exit handler for sqlwarning rollback;

START TRANSACTION;

insert into personal_profile (FirstName,LastName )      values (Fname,LName);

select  membe_id into memid from users order by  memberPF_id desc limit 1;

insert into profile(Member_ID,College,course) values(memid,Collg, course);


COMMIT;

END $$

DELIMITER ;