Answered: entName VARCHAR(255) ) BEGIN  SELECT *…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

My sql and their execution: 1. Query: DELIMITER // CREATE PROCEDURE displayStudents(  IN departmentName VARCHAR(255) ) BEGIN  SELECT *   FROM Students  WHERE Department=departmentName; END // DELIMITER ; CALL displayStudents('SCOPE'); 2. Query: DELIMITER $$ CREATE PROCEDURE countStudents(  IN location VARCHAR(25),  OUT total INT ) BEGIN  SELECT COUNT(*)  INTO Total  FROM Students  WHERE Address = location; END$$ DELIMITER ; CALL countStudents('Mumbai',@total); SELECT @total; 3. Query: DELIMITER // CREATE PROCEDURE DisplayName() BEGIN  SELECT NAME  FROM Students END;// DELIMITER ; CALL DisplayName().

11:13
For the given table below
ID NAME AGE Marks Department Address
1.
Using IN parameter, find the students who are from SCOPE Department.
2.
Using OUT parameter, count the number of students coming from Mumbai.
3. Develop a stored procedure that creates a name list of all students.
a. All the queries should be executed in MySQL and Screen Shot has to be attached for each question.
X

Expert Solution

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions