Found at http://lists.mysql.com/mysql/225525 that "hsv" wrote on 12 Aug 2011:
> Function TIME yields a string, not any timestamp type, but "d" is of some
> such type.
> Unhappily, the HTML help that I downloaded is of no help in this case, when
> the result
> context has no type, unless it is sup
- Original Message -
> From: "David Lerer"
>
> Thanks Bier. I see what you mean.
> (As a rule we always use SQL SECURITY INVOKER)
Both have their use, although I would very much prefer MySQL to default to
INVOKER if not specified, instead of the extremely annoying-when-migrating
DEFINE
Thanks Bier. I see what you mean.
(As a rule we always use SQL SECURITY INVOKER)
David.
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Thursday, August 18, 2011 4:20 AM
To: David Lerer
Cc: mysql@lists.mysql.com
Subject: Re: Concerned : Developer getting There
- Original Message -
> From: "David Lerer"
>
> Correct me if I am wrong, but my impression is that usage of
> "DEFINER=" in stored procedures has no impact on runtime and
> is actually optional.
> (not to be confused with the clause SQL SECURITY INVOKER which is
> crucial.)
You can also
