MySQL Stored procedure : Declare variables and insert

Question

Hi,

 

I want to declare some variables statically and i want to insert it into tables.

 

I have following code:

 

 declare IN Type varchar(30) = 'ABC',
         IN Zone varchar(30) = 'A1',
         IN Contact varchar(30)='9887766',
         IN Contact2 varchar(30) = '782763'
BEGIN

INSERT INTO agent
                    VALUES
   (Type, Zone, Contact, Contact2)
END

I am not able to insert values into table..

 

Please refine this script so that i can execute and insert values to table via this.