How to run pl/sql code in mysql

Results 1 to 10 of 10

Thread: How to run pl/sql code in mysql

  1. #1
    Broken In sganesh's Avatar
    Join Date
    Nov 2007
    Location
    Chennai
    Posts
    113

    Default How to run pl/sql code in mysql

    hi,
    i am using WAMP Server,I am using mysql query browser for create,updating database,
    once i ve studied pl/sql programming in oracle,,
    is it possible to run such code in Mysql Database?
    Popular Gadget Deals

  2. #2
    हॉर्न ओके प्लीज़ victor_rambo's Avatar
    Join Date
    Sep 2007
    Posts
    1,490

    Default Re: How to run pl/sql code in mysql

    You cannot use PL in MySQL query browser. PL, actually just parses thhe variables and creates the final SQL statement. You have to send this SQL to the MySQL enegine. What you can do is use PL to output the SQL and then copy-paste the SQL in the MySQL browser.
    विक्टर रॅंबो - चाणकया प्रभावित व्यक्ति

    गीक होना माँगता

  3. #3
    Broken In sganesh's Avatar
    Join Date
    Nov 2007
    Location
    Chennai
    Posts
    113

    Default Re: How to run pl/sql code in mysql

    Quote Originally Posted by rohan_shenoy View Post
    You cannot use PL in MySQL query browser. PL, actually just parses thhe variables and creates the final SQL statement. You have to send this SQL to the MySQL enegine. What you can do is use PL to output the SQL and then copy-paste the SQL in the MySQL browser.
    Hmmm,But how to use pl code to output sql,?
    could it be still more clear for me to understand?

  4. #4
    हॉर्न ओके प्लीज़ victor_rambo's Avatar
    Join Date
    Sep 2007
    Posts
    1,490

    Default Re: How to run pl/sql code in mysql

    You cannot use WAMP server for perl. You need XAMPP.
    विक्टर रॅंबो - चाणकया प्रभावित व्यक्ति

    गीक होना माँगता

  5. #5
    Broken In sganesh's Avatar
    Join Date
    Nov 2007
    Location
    Chennai
    Posts
    113

    Default Re: How to run pl/sql code in mysql

    No i am not asking about PERL.
    i need info about PL/SQL(SQL PLUS) code that we use in oracle!
    ,The same can be implemented in Mysql or not?
    Didn't u get?

  6. #6
    Commander in Chief QwertyManiac's Avatar
    Join Date
    Jul 2005
    Posts
    6,657

    Default Re: How to run pl/sql code in mysql

    Something of the sort is present in MySQL 5.0 and upwards (N/A in 4.x). They are known as "Stored Procedures and Triggers" in MySQL. For starters, check this article: http://dev.mysql.com/tech-resources/...rocedures.html
    Harsh J
    www.harshj.com

  7. #7
    Broken In sganesh's Avatar
    Join Date
    Nov 2007
    Location
    Chennai
    Posts
    113

    Default Re: How to run pl/sql code in mysql

    ok fien,i ve tried procedures and function in MySQL,
    But i Guess pl/sql programming found in oracle ,is really missing in MySQL

  8. #8
    Commander in Chief QwertyManiac's Avatar
    Join Date
    Jul 2005
    Posts
    6,657

    Default Re: How to run pl/sql code in mysql

    Yeah, the full extent of it is not found in MySQL.
    Harsh J
    www.harshj.com

  9. #9
    CAFEBABE chandru.in's Avatar
    Join Date
    Mar 2008
    Location
    Bangalore
    Posts
    474

    Default Re: How to run pl/sql code in mysql

    pl/sql cannot be found verbatim on any DB server other than Oracle's. PostgreSQL has a similar language called pl/pgSQL. You can have a look at it.
    Chandru

    http://tuxychandru.blogspot.com

  10. #10
    Broken In sganesh's Avatar
    Join Date
    Nov 2007
    Location
    Chennai
    Posts
    113

    Default Re: How to run pl/sql code in mysql

    Thanks to above all!!!

Similar Threads

  1. lock code..not security code
    By magneticme200 in forum Mobiles and Tablets
    Replies: 3
    Last Post: 29-12-2007, 07:15 PM
  2. php-mysql source code
    By mamann in forum Software Q&A
    Replies: 2
    Last Post: 23-07-2007, 01:20 AM
  3. php+mySQL help..
    By the.kaushik in forum Open Source
    Replies: 3
    Last Post: 28-02-2007, 05:07 PM
  4. Mysql Help
    By Desi-Tek.com in forum Open Source
    Replies: 4
    Last Post: 27-11-2006, 12:24 PM
  5. SQL & MySQL
    By Trinity in forum QnA (read only)
    Replies: 2
    Last Post: 05-07-2005, 07:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Close