{"id":4678,"date":"2024-03-14T01:47:27","date_gmt":"2024-03-14T01:47:27","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/"},"modified":"2025-07-31T11:40:18","modified_gmt":"2025-07-31T11:40:18","slug":"how-to-create-and-call-stored-procedures-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/","title":{"rendered":"MySQL Stored Procedures: Create & Call Guide"},"content":{"rendered":"

To create and call stored procedures in MySQL, the following steps can be used:<\/p>\n

    \n
  1. Create a stored procedure:<\/li>\n<\/ol>\n
    DELIMITER \/<\/span>\/<\/span>\r\nCREATE<\/span> PROCEDURE<\/span> my_procedure()\r\nBEGIN<\/span>\r\n    -- \u5728\u8fd9\u91cc\u7f16\u5199\u5b58\u50a8\u8fc7\u7a0b\u7684\u4ee3\u7801<\/span>\r\nEND<\/span> \/<\/span>\/<\/span>\r\nDELIMITER ;\r\n<\/code><\/pre>\n
      \n
    1. Call a stored procedure.<\/li>\n<\/ol>\n
      CALL<\/span> my_procedure();\r\n<\/code><\/pre>\n
      When creating a stored procedure, begin by changing the statement terminator to \/\/ using DELIMITER, then use the CREATE PROCEDURE statement to define the name and parameters (if any) of the stored procedure, and write the code for the stored procedure between BEGIN and END. Finally, reset the statement terminator to ; using DELIMITER.<\/p>\n
      When calling a stored procedure, use the CALL statement followed by the name of the stored procedure and its parameters (if any) to execute the stored procedure.<\/p>\n","protected":false},"excerpt":{"rendered":"
      To create and call stored procedures in MySQL, the following steps can be used: Create a stored procedure: DELIMITER \/\/ CREATE PROCEDURE my_procedure() BEGIN — \u5728\u8fd9\u91cc\u7f16\u5199\u5b58\u50a8\u8fc7\u7a0b\u7684\u4ee3\u7801 END \/\/ DELIMITER ; Call a stored procedure. CALL my_procedure(); When creating a stored procedure, begin by changing the statement terminator to \/\/ using DELIMITER, then use the CREATE […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[4444,4443,494,4408,569],"class_list":["post-4678","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-call-procedure","tag-create-procedure","tag-database-optimization","tag-mysql-stored-procedures","tag-sql-tutorial"],"yoast_head":"\nMySQL Stored Procedures: Create & Call Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to create and call MySQL stored procedures with step-by-step examples. Optimize database operations efficiently.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Stored Procedures: Create & Call Guide\" \/>\n<meta property=\"og:description\" content=\"Learn to create and call MySQL stored procedures with step-by-step examples. Optimize database operations efficiently.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T01:47:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T11:40:18+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"MySQL Stored Procedures: Create & Call Guide\",\"datePublished\":\"2024-03-14T01:47:27+00:00\",\"dateModified\":\"2025-07-31T11:40:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\"},\"wordCount\":107,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"call procedure\",\"create procedure\",\"database optimization\",\"MySQL stored procedures\",\"sql tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\",\"name\":\"MySQL Stored Procedures: Create & Call Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:47:27+00:00\",\"dateModified\":\"2025-07-31T11:40:18+00:00\",\"description\":\"Learn to create and call MySQL stored procedures with step-by-step examples. Optimize database operations efficiently.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Stored Procedures: Create & Call Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Stored Procedures: Create & Call Guide - Blog - Silicon Cloud","description":"Learn to create and call MySQL stored procedures with step-by-step examples. Optimize database operations efficiently.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Stored Procedures: Create & Call Guide","og_description":"Learn to create and call MySQL stored procedures with step-by-step examples. Optimize database operations efficiently.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:47:27+00:00","article_modified_time":"2025-07-31T11:40:18+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"MySQL Stored Procedures: Create & Call Guide","datePublished":"2024-03-14T01:47:27+00:00","dateModified":"2025-07-31T11:40:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/"},"wordCount":107,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["call procedure","create procedure","database optimization","MySQL stored procedures","sql tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/","name":"MySQL Stored Procedures: Create & Call Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:47:27+00:00","dateModified":"2025-07-31T11:40:18+00:00","description":"Learn to create and call MySQL stored procedures with step-by-step examples. Optimize database operations efficiently.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-and-call-stored-procedures-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Stored Procedures: Create & Call Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4678"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4678\/revisions"}],"predecessor-version":[{"id":149373,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4678\/revisions\/149373"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}