How to create a basic stored procedure in mysql.

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
14,184
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 1, 2008

Quick tut on how to create a stored procedure in mysql and call it as a normal sql query using sql yog.

Category:

Science & Technology

Tags:

License:

Standard YouTube License

  • likes, 2 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • how can i create a stored procedure with phpmyadmin?

  • Thanks! That's quite helpful. I'm starting to make better use of stored procedures, though wish my skills were a little more attuned in relation to my other MySQL skills.

  • @TAz69x stored procedures are actually pre-compiled. When you use PHP to do send a lot of query strings they have to be compiled one for one. As for stored procedures this is not needed resulting in some performance gain.

  • Thanks N3ddya :D

  • What is the speed like when comparing handling the logic with a PHP script, and having MySQL handle the logic?

    I've always used PHP to handle the logic portion of scripting, but see every once in a while someone who prefers using stored procedures (or other methods).

  • THankz this really helped me!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more