By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

how to execute pl/sql using mysql?

P: 54
I have this kind of code :
Expand|Select|Wrap|Line Numbers
  1. Declare
  2. a number;
  3. s1 number default 0;
  4. Begin
  5. a:=1;
  6. loop
  7. s1:=s1+a;
  8. exit when (a=100);
  9. a:=a+1;
  10. end loop;
  11. dbms_output.put_line('Sum between 1 to 100 is '||s1);
  12. End;
I stored it into one p2.sql file and now wanna execute it using mysql , how can i do it?
Sep 14 '12 #1

✓ answered by johny10151981

pl/sql is for oracle. MySql support procedure, try searchign about mysql procedure

Share this Question
Share on Google+
1 Reply


100+
P: 1,059
pl/sql is for oracle. MySql support procedure, try searchign about mysql procedure
Sep 23 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.