Skip to main content

Home/ MySQL/ Contents contributed and discussions participated by Ken Wei

Contents contributed and discussions participated by Ken Wei

Simple Middle Filter: All | Bookmarks | Topics
Ken Wei

MySQL AB :: MySQL 5.0 Reference Manual :: 17.2.6 DECLARE Statement Syntax - 0 views

dev.mysql.com/...declare.html

mysql procedure

shared by Ken Wei on 03 Mar 07 - Cached
  • Declarations must follow a certain order. Cursors must be declared before declaring handlers, and variables and conditions must be declared before declaring either cursors or handlers.
  • DECLARE is allowed only inside a BEGIN ... END compound statement and must be at its start, before any other statements.
Ken Wei

MySQL AB :: MySQL 5.0 Reference Manual :: 17.2.1 CREATE PROCEDURE and CREATE FUNCTION S... - 0 views

dev.mysql.com/...create-procedure.html

mysql procedure

shared by Ken Wei on 03 Mar 07 - Cached
  • Each parameter is an IN parameter by default. To specify otherwise for a parameter, use the keyword OUT or INOUT before the parameter name.
  • Specifying a parameter as IN, OUT, or INOUT is valid only for a PROCEDURE. (FUNCTION parameters are always regarded as IN parameters.)
Ken Wei

MySQL Lists: mysql: Re: triggers on 5.0.17 -- definer not fully qualified - 0 views

lists.mysql.com/193588

mysql

shared by Ken Wei on 03 Mar 07 - Cached
  • Ken Wei on 03 Mar 07
     
    5.0.18 still has the same issue.
« First ‹ Previous 41 - 60 of 69 Next ›
Showing 20▼ items per page