Magento Expert Forum - Improve your Magento experience

Results 1 to 3 of 3

Basics of MY SQL Stored Procedure

  1. #1
    Junior Member
    Join Date
    Apr 2014
    Posts
    104
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Thumbs up Basics of MY SQL Stored Procedure

    Hi Mates,

    Today I'm going to share SQL stored procedures and how to implement this....

    CREATE
    [DEFINER = { user | CURRENT_USER }]
    PROCEDURE sp_name ([proc_parameter[,...]])
    [characteristic ...] routine_body
    proc_parameter:
    [ IN | OUT | INOUT ] param_name type
    type:
    Any valid MySQL data type
    characteristic:
    COMMENT 'string'
    | LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    routine_body:
    Valid SQL routine statement
    To be continued in: http://bit.ly/1qxDf5e

    View more threads in the same category:


  2. #2
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    156
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    A put away technique is a lot of Structured Query Language (SQL) explanations with an appointed name, which are put away in a social database the board framework as a gathering, so it tends to be reused and shared by different projects.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •