Re: Extending/modifying MySQL around stored procedures

[Nigel Rudd]

Peter Brawley Wrote:
-------------------------------------------------------
> Such mods would change how the DB works; how would
> that illuminate how the DB works?
Hmmm.. it would change how the database works, but it
will fundamentally still be the same. To understand
how a stored procedure is translated into it's pseudo
code can help in optimizing code.

> By "define a variable as being the same as a field
> on a table" do you mean define a var holding the
> name of the field, or define a var holding all its
> values in the table where it occurs?
Neither - I'm more referring to something like %TYPE
which Oracle allows.

> Suggestion: learn thoroughly how to use MySQL
> before you set about changing it.
I'm the sort of person who learns how a TV works
by taking it apart :)