SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Jun 2006
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Where to write stored procedure in mysql

    Where do I need to write stored procedure in mysql? Do I need to write them in a php file or in some other interface?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,015
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by neel1979 View Post
    Where do I need to write stored procedure in mysql? Do I need to write them in a php file or in some other interface?
    stored procedures are defined right in mysql, the same way that tables are defined right in mysql
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Jun 2006
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    so i have to write and storte procedures in phpmyadmin itself? if so where in phpmyadmin?how can i access the already created stored procedures in phpmyadmin. pls explain in details as I dont have much idea

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,015
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by neel1979 View Post
    so i have to write and storte procedures in phpmyadmin itself?
    no

    phpmyadmin is a front-end tool for mysql (and, in my opinion, not a very good one)

    when you use a "point-and-click" interface, it's actually just building SQL queries underneath

    and while there is a "friendly" way to create a table by filling in form fields in phpmyadmin, you can always create a table using ordinary SQL, the CREATE TABLE statement, and execute it in the SQL window that phpmyadmin provides

    my advice is to learn the SQL so that you are not limited by what the front-end interface can do, but rather, you can do everything yourself

    read the manual on the CREATE PROCEDURE statement
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •