Public Pastes
daily pastebin goal
91%
SHARE
TWEET

Untitled

a guest Oct 12th, 2018 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP PROCEDURE IF EXISTS sp1;
  2.  
  3. DELIMITER $$
  4.  
  5. CREATE PROCEDURE sp1(IN para1 INT, IN para2 INT,IN para3 INT)
  6.  
  7. BEGIN
  8.  
  9. INSERT INTO table100 VALUES(
  10. NULL, #AaS_id, Auto_Increment
  11. DEFAULT, #AaS_ts, Def
  12. SELECT info1 FROM table2 WHERE id1 = para1,
  13. SELECT info2 FROM table3 WHERE id2 = para2,
  14. para3);
  15.  
  16. END$$
  17.  
  18. DELIMITER ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top