Stored Procedure: Add Employee

Create a stored procedure add_employee(name, salary) that inserts a new employee with the next available id and the given name and salary.

Table schema

Employees(id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50), salary INT)

Sample data

Call: CALL add_employee('Asha', 50000);