CREATE DEFINER=root@localhost PROCEDURE item_page_insert(IN cid INT, IN it_title VARCHAR(200), IN tumbnail VARCHAR(300), IN publish_date DATE, IN cover_set VARCHAR(20), IN pcontent TEXT, IN status INT) MODIFIES SQL DATA
 BEGIN
DECLARE mpid INT;
SELECT max(pid)+1 INTO mpid
FROM tbpage;
INSERT INTO tbite(cid, pid, it_title, tumbnail, publish_date, cover_set)
VALUES(cid,
       mpid,
       it_title,
       tumbnail,
       publish_date,
       cover_set);
INSERT INTO tbpage(pid, pcontent, set_date, status)
VALUES(mpid,
       pcontent,
       now(),
       status); END;

 DELIMITER ;