I need basic info and an example.
Enter your MySQL question at the top of this page and click Get An Answer.
Tell us how quickly you want your MySQL question answered.
Connect with your programmer via online chat or telephone call.
I need basic info and an example.
here is the basic structure:
Create procedure with IN parameter:
CREATE OR REPLACE PROCEDURE sample (x VARCHAR) IS
"BEGIN "
"INSERT INTO sample_table VALUES(x); "
"END;";
Create procedure with OUT parameter:
CREATE OR REPLACE PROCEDURE sample1(x OUT VARCHAR) IS
"BEGIN "
"INSERT INTO sample1_table VALUES('string 2'); "
"x := 'outvalue'; " // Assign a value to x
"END;";
I hope it will help, for further information visit http://www.mysql.com/
thank you.
Byron Narciso
Programmer
Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.
ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!