Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
MySQL Stored procedure : Declare variables and insert
Rp Singh
Dec 27 2017 1:07 AM
171
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
i want to learn about hadoop?
what is apache pig?