Error 1064 in a stored procedure in MySQL 8.0





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I am using MySQL Workbench 8.0 CE and i'm trying to create a stored procedure to show 2 fields from my table. I am receiving the following error:



Error Code: 1064. You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version
for the right syntax to use near '' at line 3


This is my table:



CREATE TABLE student (
id INT PRIMARY KEY,
name VARCHAR(200),
age INT,
final_grade DOUBLE,
sex VARCHAR(1)
)


And this is the procedure:



CREATE PROCEDURE show_name_grade () 
BEGIN
SELECT name,final_grade FROM student;
END









share|improve this question































    0















    I am using MySQL Workbench 8.0 CE and i'm trying to create a stored procedure to show 2 fields from my table. I am receiving the following error:



    Error Code: 1064. You have an error in your SQL syntax; 
    check the manual that corresponds to your MySQL server version
    for the right syntax to use near '' at line 3


    This is my table:



    CREATE TABLE student (
    id INT PRIMARY KEY,
    name VARCHAR(200),
    age INT,
    final_grade DOUBLE,
    sex VARCHAR(1)
    )


    And this is the procedure:



    CREATE PROCEDURE show_name_grade () 
    BEGIN
    SELECT name,final_grade FROM student;
    END









    share|improve this question



























      0












      0








      0








      I am using MySQL Workbench 8.0 CE and i'm trying to create a stored procedure to show 2 fields from my table. I am receiving the following error:



      Error Code: 1064. You have an error in your SQL syntax; 
      check the manual that corresponds to your MySQL server version
      for the right syntax to use near '' at line 3


      This is my table:



      CREATE TABLE student (
      id INT PRIMARY KEY,
      name VARCHAR(200),
      age INT,
      final_grade DOUBLE,
      sex VARCHAR(1)
      )


      And this is the procedure:



      CREATE PROCEDURE show_name_grade () 
      BEGIN
      SELECT name,final_grade FROM student;
      END









      share|improve this question
















      I am using MySQL Workbench 8.0 CE and i'm trying to create a stored procedure to show 2 fields from my table. I am receiving the following error:



      Error Code: 1064. You have an error in your SQL syntax; 
      check the manual that corresponds to your MySQL server version
      for the right syntax to use near '' at line 3


      This is my table:



      CREATE TABLE student (
      id INT PRIMARY KEY,
      name VARCHAR(200),
      age INT,
      final_grade DOUBLE,
      sex VARCHAR(1)
      )


      And this is the procedure:



      CREATE PROCEDURE show_name_grade () 
      BEGIN
      SELECT name,final_grade FROM student;
      END






      mysql sql mysql-error-1064






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 16 '18 at 19:02









      Michael Lihs

      2,63742547




      2,63742547










      asked Nov 16 '18 at 18:56









      EwroEwro

      11




      11
























          1 Answer
          1






          active

          oldest

          votes


















          0














          You will need to redefine Delimiter to something else other than ;. At the end, define it back to ;



          DELIMITER $$
          CREATE PROCEDURE show_name_grade ()
          BEGIN
          SELECT name,final_grade FROM student;
          END $$
          DELIMITER ;





          share|improve this answer
























          • that was it! thanks

            – Ewro
            Nov 16 '18 at 21:03











          • @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

            – Chowkidar Madhur Bhaiya
            Nov 22 '18 at 20:52












          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53343837%2ferror-1064-in-a-stored-procedure-in-mysql-8-0%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          You will need to redefine Delimiter to something else other than ;. At the end, define it back to ;



          DELIMITER $$
          CREATE PROCEDURE show_name_grade ()
          BEGIN
          SELECT name,final_grade FROM student;
          END $$
          DELIMITER ;





          share|improve this answer
























          • that was it! thanks

            – Ewro
            Nov 16 '18 at 21:03











          • @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

            – Chowkidar Madhur Bhaiya
            Nov 22 '18 at 20:52
















          0














          You will need to redefine Delimiter to something else other than ;. At the end, define it back to ;



          DELIMITER $$
          CREATE PROCEDURE show_name_grade ()
          BEGIN
          SELECT name,final_grade FROM student;
          END $$
          DELIMITER ;





          share|improve this answer
























          • that was it! thanks

            – Ewro
            Nov 16 '18 at 21:03











          • @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

            – Chowkidar Madhur Bhaiya
            Nov 22 '18 at 20:52














          0












          0








          0







          You will need to redefine Delimiter to something else other than ;. At the end, define it back to ;



          DELIMITER $$
          CREATE PROCEDURE show_name_grade ()
          BEGIN
          SELECT name,final_grade FROM student;
          END $$
          DELIMITER ;





          share|improve this answer













          You will need to redefine Delimiter to something else other than ;. At the end, define it back to ;



          DELIMITER $$
          CREATE PROCEDURE show_name_grade ()
          BEGIN
          SELECT name,final_grade FROM student;
          END $$
          DELIMITER ;






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 16 '18 at 19:19









          Chowkidar Madhur BhaiyaChowkidar Madhur Bhaiya

          19.8k62336




          19.8k62336













          • that was it! thanks

            – Ewro
            Nov 16 '18 at 21:03











          • @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

            – Chowkidar Madhur Bhaiya
            Nov 22 '18 at 20:52



















          • that was it! thanks

            – Ewro
            Nov 16 '18 at 21:03











          • @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

            – Chowkidar Madhur Bhaiya
            Nov 22 '18 at 20:52

















          that was it! thanks

          – Ewro
          Nov 16 '18 at 21:03





          that was it! thanks

          – Ewro
          Nov 16 '18 at 21:03













          @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

          – Chowkidar Madhur Bhaiya
          Nov 22 '18 at 20:52





          @Ewro Please see: How to accept an answer for closure. You get points for it as well. Thanks :)

          – Chowkidar Madhur Bhaiya
          Nov 22 '18 at 20:52




















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53343837%2ferror-1064-in-a-stored-procedure-in-mysql-8-0%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Florida Star v. B. J. F.

          Danny Elfman

          Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues