|
Posted by Cerebral Believer on September 17, 2006, 10:59 am
Please log in for more thread options
>
>> 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
>
> Thanks, I keep getting Error #1064, but the same syntax works fine for a
> simple query.
>
> CREATE FUNCTION Sum_001R RETURNS INT
> SELECT SUM(`Quantity Ordered`) FROM `Sales Detail Information`
> WHERE`Catalogue Number` = "FBDCD008";
>
> I am perplexed.
OK,
I found the answer, again quite simple, but requiring back-tick quotes
(which I had not put round the proceedure name), which is not specified on
the MySQL website, neither in the reference material or the examples. So
this works:
CREATE PROCEDURE `008_sales`()
SELECT SUM(`Quantity Ordered`) FROM `Sales Detail Information` WHERE
`Catalogue Number` = "FBDCD008";
Anyone know how I can get a column to automatically run that procedure? Is
that even possible?
Regards,
C.B.
| 
XML Sitemap