Using MySQL....Please respond with the necessary statements

Project 2 is about printing variables for a single record from DDI.LEDGER_VIEW using PL/SQL

1. SPOOL your output to c:\CS4210\project2spool.txt

2. Set up variables in the DECLARE section. Use either %TYPE or %ROWTYPE

3. SELECT all the fields in DDI.LEDGER_VIEW where REGID is to be determined at run time.

4. Use DBMS__OUTPUT.OUTPUT_LINE to print the values for each field.

5. Compile and run the procedure for the REGID 17

Thank you