1. Write a stored procedure to find the earliest registration date by a OUT parameter. (use function min() 

2. Write a st stored procedure to find the registration date by a IN user_id parameter and a OUT parameter 

3. Write a stored procedure to add a new user. Provide IN parameters of user_id, first_name, last_name, email, pass and registration_date. 

4. Write a stored procedure to delete a user by providing an IN user_id 

5. Write a stored procedure to retrieve all the records from users table? 

6. Write a stored procedure to update the email of a user by an IN user_id and IN email parameters.

Answer rating: 100% (QA)

1 Stored Procedure to find the earliest registration date sql CREATE PROCEDURE GetEarliestRegistrati... View the full answer