Advertisement
attila66

MySQL Procedure with more ResultSet

May 5th, 2020
1,241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 KB | None | 0 0
  1. CREATE TABLE person(
  2.   id INT PRIMARY KEY,
  3.   name CHAR(15),
  4.   city CHAR(15)
  5. );
  6. INSERT INTO person VALUES (1,'A','London'),(2,'B','Paris'),(3,'C','Paris');
  7.  
  8. DELIMITER $$
  9.  
  10. CREATE PROCEDURE MyProcedure(IN pCity CHAR(15))
  11. BEGIN
  12.   DECLARE myVar INT;
  13.   SELECT * FROM person WHERE city=pCity;
  14.   SELECT count(*) INTO myVar FROM person;
  15.   SELECT name, city FROM person;
  16. END$$
  17.  
  18. DELIMITER ;
  19.  
  20. CALL MyProcedure('Paris');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement