title: how to write multiple Insert queries in single procedure?
body: <p>how to write multiple Insert queries in single procedure?</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_Insert`(IN `newt` VARCHAR(500), IN `news` TEXT, IN `status` VARCHAR(500), IN `ntype` VARCHAR(500), IN `img_file` VARCHAR(1500), IN `vlink` VARCHAR(500))
  INSERT INTO tbl_news(newt, news, status, ntype) VALUES (newt,news,status,ntype);
  SET LID = LAST_INSERT_ID();
  INSERT INTO tbl_img(pic, cid, imgfile, imgtype, imgstatus) VALUES (LID,LID,img_file,ntype,status);
  INSERT INTO tbl_video(cid, vlink, vdis, vstatus) VALUES (LID,v_link,news,status);
  </code></pre>
  
  <p>This is the first time i am using this stored procedure.</p>