hi everyone,

im just finishing off my database design and development assignment and im kinda stuck on one part so im hoping someone can help me!

the assignment case study was about an airline serives for UWS,

i need to: list the identified verbs in the document to help determine any stored procedures. then provide 4 - 5 sample stored procedure specifications and a short description for each. No need to write the actual stored procedure in SQL.

ive lost my textbook unfortunately, and my lecture notes havent gone thru stored procedures so i dont really get it

id really appreciate any help

Stored procedure = a bunch of SQL commands stored in the database to do a particular function. Like to add, retrieve, or modify data that might live in several tables, which might include logging the change, or anything else.

It is a bit unclear from your post what you are actually looking for.

Hi

i didnt get ur query
do u mean u r unable to view the created stored procedures
if so ....
in phpmyadmin - select "information_schema" database - in SQL tab provide "select * from routines" and execute this query then u can view all the existing procedures. If ur mysql version is 5.0.5 or higher u can view all the list of procedures under the tables list.

I have another query:
i am able to create and view procedures at phpmyadmin
should i use call / execute statement in order to get those results of created stored procedure at phpmyamin

thanks..

Sorry for the slightly spammy post, but I'm just now releasing a new open source project called phpMyIDE which is a MySQL stored procedure, function and trigger management app. It's all PHP, JS and Ajax and I am looking for stored procedure people to assist me with testing.

It can be found here: http://www.phpmyide.com/

Thanks in advance!