Exercises, examples and other material relating to training module S163. This module is presented on
Private Courses and
Specially Run Courses only
Articles and tips on this subject | updated |
2749 | Delegate Question - defining MySQL table relationships as you create the tables Q - Can define how tables are linked (joined together) when you set them up in MySQL, rather than having to specify the join each time that you SELECT data from the tables?
What a great (and logical) idea, but it's not straightforward / automatically available. The current / default system in the ... | 2010-05-02 |
2447 | MySQL stored procedures / their use on the web from PHP Are there times when your PHP will pull a large result set back from MySQL, or have to make a large number of queries, just to further process the data into a relatively small dynamic section of a report? If so, why not have the MySQL do more of the work and return a much shorter, more processes results ... | 2009-10-10 |
2446 | Learn about MySQL stored procedures Current releases of MySQL include "stored procedures". What are they?
You may start by considering stored procedures to be "Macros" - a series of commands bunched together as one, or a complex command which is held within the MySQL daemon and called up by just a simple call. But they then go much ... | 2009-10-09 |
Examples from our training material
seed.sql | Data to seed tables for stored procedure demos |
stored3.php | PHP call to a stored procedure to run a fixed query |
stored4.php | PHP call to a MySQL stored procedure passing a parameter |
stored5.php | PHP call to a MySQL stored procedure that returns a result set |
stored6.php | PHP call to a MySQL store procedure that calculates / loops |
stp3 | Simple stored procedure definition |
stp4 | Stored procedure to return a result set |
stp5 | Stored Procedure taking a parameter |
stp6 | Stored procedure calculating from a query |
twcrp.sql | MySQLdump sample - twcrp test database for store procedure use |
Background information
Some modules are
available for download as a sample of our material or under an
Open Training Notes License for free download from
[here].
Topics covered in this module
What are stored procedures, functions and triggers?
Accessing tables within stored procedures.
Variables, conditionals and loops.
Cursors and handling end of query conditions.
Creating, showing and dropping stored procedures.
Complete learning
If you are looking for a complete course and not just a information on a single subject, visit our
Listing and schedule page.
Well House Consultants specialise in training courses in
Ruby,
Lua,
Python,
Perl,
PHP, and
MySQL. We run
Private Courses throughout the UK (and beyond for longer courses), and
Public Courses at our training centre in Melksham, Wiltshire, England.
It's surprisingly cost effective to come on our public courses -
even if
you live in a different
country or continent to us.
We have a technical library of over 700 books on the subjects on which we teach.
These books are available for reference at our training centre.