Re: FN-FORUM: MySQL Query Problems

date posted 31st January 2006 16:25

Ben Moxon wrote:
>
> [EMAIL REMOVED] wrote:
>
>> Does MySQL have the ability to built queries into the DB? I didn't think
>> it could have them?
>
> No, it doesn't- certainly not in the older versions, which are fine for
> basic stuff but only just count as databases for anything more than
> that- but you can use complex SQL and built in database functions where
> possible and it will still work faster than doing it in your PHP or ASP
> or whatever. It's not like having stored procedures, but better than nowt.

MySQL 5.0 adds support for stored procs.

http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

But no-one's using version 5.0 as far as I can tell. Most web hosting
solutions that include databases as a feature seem to have MySQL 3.23 or
thereabouts. And that's not a database. That's a data file with an
SQL-esque query language.

Sigh. Well I suppose it's a step up from Access.

Dave...
[ Attempting to install Sybase for Linux tonight]

--
Magnum Solutions Ltd
Open Source Consultancy, Development and Training