|
Posted by NC on 10/03/26 11:58
Cerebral Believer wrote:
>
> I have the following statement:
>
> SELECT SUM(`Quantity Ordered`)
> FROM `Sales Detail Information` WHERE
> `Catalogue Number` = "FBDCD008";
>
> I can run this as a query in the SQL window, and it works fine.
>
> How could I turn this query into a FUNCTION or perhaps
> better still a PROCEEDURE? I am not sure if FUNCTIONS
> can reference tables...
Read MySQL documentation:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
Cheers,
NC
Navigation:
[Reply to this message]
|