MySQL Stored procedure : Declare variables and insert

Ms_ Dev

Hi,

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

I have following code:

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar8y ago
Hi,
Use the below query.

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

INSERT INTO `agent` VALUES (Type, Zone, Contact, Contact2)
END
Sagar Pandurang Kap8y ago
1. For declaration try this
3. //Declare all variables
4. DECLARE type varchar(30);
5. DECLARE zone varchar(30);
6. DECLARE contact varchar(30);
7. DECLARE contact2 varchar(30);
9. //Assign value after declaration like below
10. SET type = 'ABC';
11. SET zone = 'A1';
12. SET contact = '9887766';
13. SET contact2 = '782763';
15. BEGIN
16. INSERT INTO agent VALUES (type , zone , contact , contact2 )
17. END
19. Hope it will helps.
Ms_ Dev8y ago
i think script is wrong. Does MySQL supports declare ?

Can you please review this script one more time..
Sagar Pandurang Kap8y ago
What kind of error you are getting??