SHARE
TWEET

Untitled




Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- DROP PROCEDURE IF EXISTS sp1;
- DELIMITER $$
- CREATE PROCEDURE sp1(IN para1 INT, IN para2 INT,IN para3 INT)
- BEGIN
- INSERT INTO table100 VALUES(
- NULL, #AaS_id, Auto_Increment
- DEFAULT, #AaS_ts, Def
- SELECT info1 FROM table2 WHERE id1 = para1,
- SELECT info2 FROM table3 WHERE id2 = para2,
- para3);
- END$$
- 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.