DELIMITER // 
CREATE PROCEDURE `insert_select_object`(name varchar(30), description text, keywords tinytext,
	 createdAt datetime, updatedAt datetime, folderID int(11))
LANGUAGE SQL 
BEGIN 
    DECLARE EXIT HANDLER FOR SQLEXCEPTION,NOT FOUND,SQLWARNING
    BEGIN
        ROLLBACK;
        RESIGNAL;
    END;
       
    START TRANSACTION;  
    
    INSERT INTO
    `object`
    SET
   `name` = name,
   `description` = description,
   `keywords` = keywords,
   `createdAt` = createdAt,
   `updatedAt` = updatedAt,
   `folderID` = folderID;
    
    SELECT * from `object` where id = (SELECT LAST_INSERT_ID() FROM `tests` limit 1);
    COMMIT;    
END;//