Magento Expert Forum - Improve your Magento experience
-
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:
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks