Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE person(
- id INT PRIMARY KEY,
- name CHAR(15),
- city CHAR(15)
- );
- INSERT INTO person VALUES (1,'A','London'),(2,'B','Paris'),(3,'C','Paris');
- DELIMITER $$
- CREATE PROCEDURE MyProcedure(IN pCity CHAR(15))
- BEGIN
- DECLARE myVar INT;
- SELECT * FROM person WHERE city=pCity;
- SELECT count(*) INTO myVar FROM person;
- SELECT name, city FROM person;
- END$$
- DELIMITER ;
- CALL MyProcedure('Paris');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement