Mysql error #2014 - Commands out of sync; you can't run this command now in a stored procedure











up vote
1
down vote

favorite












I have the following stored procedure in mysql:



DELIMITER $$
CREATE DEFINER=`user`@`localhost` PROCEDURE `insert_patient`(IN `name` VARCHAR(45), IN `surname` VARCHAR(45), IN `middle_name` VARCHAR(45), IN `patient_gender` VARCHAR(15), IN `patient_weight` VARCHAR(15), IN `patient_height` VARCHAR(15), IN `patient_ethnic_origin` VARCHAR(45))
NO SQL
BEGIN

BEGIN
INSERT
INTO
patient(
name,
surname,
middle_name
)
VALUES(
name,
surname,
middle_name
) ;
SELECT
LAST_INSERT_ID() AS patient_local_id;
END;
BEGIN
INSERT
INTO
demographics(
patient_id,
gender,
weight,
height,
ethnic_origin
)
VALUES(
patient_local_id,
patient_gender,
patient_weight,
patient_height,
patient_ethnic_origin
) ;
END;
END$$
DELIMITER ;


When I'm trying to execute this stored-procedure from phpmyadmin I get the following error:



Unrecognized keyword. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2014 - Commands out of sync; you can't run this command now









share|improve this question






















  • The line from the error message appears nowhere in your stored proc, at least not in the code which you actually showed us. But, you should use SET FOREIGN_KEY_CHECKS = 1.
    – Tim Biegeleisen
    Nov 22 at 13:51










  • @TimBiegeleisen Do I have to include SET FOREIGN_KEY_CHECKS = 1 in my stored-procedure code?
    – zinon
    Nov 22 at 13:52










  • Well, are you already doing this in your proc code? The error message seems to be yes.
    – Tim Biegeleisen
    Nov 22 at 13:53










  • @TimBiegeleisen I don't have it in my proc code. Maybe it's something that happens by default?
    – zinon
    Nov 22 at 13:54










  • SET FOREIGN_KEY_CHECKS = ON; isn't valid MySQL AFAIK. Something must be inserting this code.
    – Tim Biegeleisen
    Nov 22 at 13:54















up vote
1
down vote

favorite












I have the following stored procedure in mysql:



DELIMITER $$
CREATE DEFINER=`user`@`localhost` PROCEDURE `insert_patient`(IN `name` VARCHAR(45), IN `surname` VARCHAR(45), IN `middle_name` VARCHAR(45), IN `patient_gender` VARCHAR(15), IN `patient_weight` VARCHAR(15), IN `patient_height` VARCHAR(15), IN `patient_ethnic_origin` VARCHAR(45))
NO SQL
BEGIN

BEGIN
INSERT
INTO
patient(
name,
surname,
middle_name
)
VALUES(
name,
surname,
middle_name
) ;
SELECT
LAST_INSERT_ID() AS patient_local_id;
END;
BEGIN
INSERT
INTO
demographics(
patient_id,
gender,
weight,
height,
ethnic_origin
)
VALUES(
patient_local_id,
patient_gender,
patient_weight,
patient_height,
patient_ethnic_origin
) ;
END;
END$$
DELIMITER ;


When I'm trying to execute this stored-procedure from phpmyadmin I get the following error:



Unrecognized keyword. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2014 - Commands out of sync; you can't run this command now









share|improve this question






















  • The line from the error message appears nowhere in your stored proc, at least not in the code which you actually showed us. But, you should use SET FOREIGN_KEY_CHECKS = 1.
    – Tim Biegeleisen
    Nov 22 at 13:51










  • @TimBiegeleisen Do I have to include SET FOREIGN_KEY_CHECKS = 1 in my stored-procedure code?
    – zinon
    Nov 22 at 13:52










  • Well, are you already doing this in your proc code? The error message seems to be yes.
    – Tim Biegeleisen
    Nov 22 at 13:53










  • @TimBiegeleisen I don't have it in my proc code. Maybe it's something that happens by default?
    – zinon
    Nov 22 at 13:54










  • SET FOREIGN_KEY_CHECKS = ON; isn't valid MySQL AFAIK. Something must be inserting this code.
    – Tim Biegeleisen
    Nov 22 at 13:54













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I have the following stored procedure in mysql:



DELIMITER $$
CREATE DEFINER=`user`@`localhost` PROCEDURE `insert_patient`(IN `name` VARCHAR(45), IN `surname` VARCHAR(45), IN `middle_name` VARCHAR(45), IN `patient_gender` VARCHAR(15), IN `patient_weight` VARCHAR(15), IN `patient_height` VARCHAR(15), IN `patient_ethnic_origin` VARCHAR(45))
NO SQL
BEGIN

BEGIN
INSERT
INTO
patient(
name,
surname,
middle_name
)
VALUES(
name,
surname,
middle_name
) ;
SELECT
LAST_INSERT_ID() AS patient_local_id;
END;
BEGIN
INSERT
INTO
demographics(
patient_id,
gender,
weight,
height,
ethnic_origin
)
VALUES(
patient_local_id,
patient_gender,
patient_weight,
patient_height,
patient_ethnic_origin
) ;
END;
END$$
DELIMITER ;


When I'm trying to execute this stored-procedure from phpmyadmin I get the following error:



Unrecognized keyword. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2014 - Commands out of sync; you can't run this command now









share|improve this question













I have the following stored procedure in mysql:



DELIMITER $$
CREATE DEFINER=`user`@`localhost` PROCEDURE `insert_patient`(IN `name` VARCHAR(45), IN `surname` VARCHAR(45), IN `middle_name` VARCHAR(45), IN `patient_gender` VARCHAR(15), IN `patient_weight` VARCHAR(15), IN `patient_height` VARCHAR(15), IN `patient_ethnic_origin` VARCHAR(45))
NO SQL
BEGIN

BEGIN
INSERT
INTO
patient(
name,
surname,
middle_name
)
VALUES(
name,
surname,
middle_name
) ;
SELECT
LAST_INSERT_ID() AS patient_local_id;
END;
BEGIN
INSERT
INTO
demographics(
patient_id,
gender,
weight,
height,
ethnic_origin
)
VALUES(
patient_local_id,
patient_gender,
patient_weight,
patient_height,
patient_ethnic_origin
) ;
END;
END$$
DELIMITER ;


When I'm trying to execute this stored-procedure from phpmyadmin I get the following error:



Unrecognized keyword. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2014 - Commands out of sync; you can't run this command now






mysql stored-procedures phpmyadmin






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 22 at 13:45









zinon

1,48442963




1,48442963












  • The line from the error message appears nowhere in your stored proc, at least not in the code which you actually showed us. But, you should use SET FOREIGN_KEY_CHECKS = 1.
    – Tim Biegeleisen
    Nov 22 at 13:51










  • @TimBiegeleisen Do I have to include SET FOREIGN_KEY_CHECKS = 1 in my stored-procedure code?
    – zinon
    Nov 22 at 13:52










  • Well, are you already doing this in your proc code? The error message seems to be yes.
    – Tim Biegeleisen
    Nov 22 at 13:53










  • @TimBiegeleisen I don't have it in my proc code. Maybe it's something that happens by default?
    – zinon
    Nov 22 at 13:54










  • SET FOREIGN_KEY_CHECKS = ON; isn't valid MySQL AFAIK. Something must be inserting this code.
    – Tim Biegeleisen
    Nov 22 at 13:54


















  • The line from the error message appears nowhere in your stored proc, at least not in the code which you actually showed us. But, you should use SET FOREIGN_KEY_CHECKS = 1.
    – Tim Biegeleisen
    Nov 22 at 13:51










  • @TimBiegeleisen Do I have to include SET FOREIGN_KEY_CHECKS = 1 in my stored-procedure code?
    – zinon
    Nov 22 at 13:52










  • Well, are you already doing this in your proc code? The error message seems to be yes.
    – Tim Biegeleisen
    Nov 22 at 13:53










  • @TimBiegeleisen I don't have it in my proc code. Maybe it's something that happens by default?
    – zinon
    Nov 22 at 13:54










  • SET FOREIGN_KEY_CHECKS = ON; isn't valid MySQL AFAIK. Something must be inserting this code.
    – Tim Biegeleisen
    Nov 22 at 13:54
















The line from the error message appears nowhere in your stored proc, at least not in the code which you actually showed us. But, you should use SET FOREIGN_KEY_CHECKS = 1.
– Tim Biegeleisen
Nov 22 at 13:51




The line from the error message appears nowhere in your stored proc, at least not in the code which you actually showed us. But, you should use SET FOREIGN_KEY_CHECKS = 1.
– Tim Biegeleisen
Nov 22 at 13:51












@TimBiegeleisen Do I have to include SET FOREIGN_KEY_CHECKS = 1 in my stored-procedure code?
– zinon
Nov 22 at 13:52




@TimBiegeleisen Do I have to include SET FOREIGN_KEY_CHECKS = 1 in my stored-procedure code?
– zinon
Nov 22 at 13:52












Well, are you already doing this in your proc code? The error message seems to be yes.
– Tim Biegeleisen
Nov 22 at 13:53




Well, are you already doing this in your proc code? The error message seems to be yes.
– Tim Biegeleisen
Nov 22 at 13:53












@TimBiegeleisen I don't have it in my proc code. Maybe it's something that happens by default?
– zinon
Nov 22 at 13:54




@TimBiegeleisen I don't have it in my proc code. Maybe it's something that happens by default?
– zinon
Nov 22 at 13:54












SET FOREIGN_KEY_CHECKS = ON; isn't valid MySQL AFAIK. Something must be inserting this code.
– Tim Biegeleisen
Nov 22 at 13:54




SET FOREIGN_KEY_CHECKS = ON; isn't valid MySQL AFAIK. Something must be inserting this code.
– Tim Biegeleisen
Nov 22 at 13:54












1 Answer
1






active

oldest

votes

















up vote
0
down vote



accepted










I found the solution. When I was executing the stored-procedure I had the following box checked.



enter image description here






share|improve this answer





















    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',
    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%2f53432383%2fmysql-error-2014-commands-out-of-sync-you-cant-run-this-command-now-in-a-st%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








    up vote
    0
    down vote



    accepted










    I found the solution. When I was executing the stored-procedure I had the following box checked.



    enter image description here






    share|improve this answer

























      up vote
      0
      down vote



      accepted










      I found the solution. When I was executing the stored-procedure I had the following box checked.



      enter image description here






      share|improve this answer























        up vote
        0
        down vote



        accepted







        up vote
        0
        down vote



        accepted






        I found the solution. When I was executing the stored-procedure I had the following box checked.



        enter image description here






        share|improve this answer












        I found the solution. When I was executing the stored-procedure I had the following box checked.



        enter image description here







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 22 at 14:27









        zinon

        1,48442963




        1,48442963






























            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.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • 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%2f53432383%2fmysql-error-2014-commands-out-of-sync-you-cant-run-this-command-now-in-a-st%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

            Contact image not getting when fetch all contact list from iPhone by CNContact

            count number of partitions of a set with n elements into k subsets

            A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks