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
mysql stored-procedures phpmyadmin
|
show 3 more comments
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
mysql stored-procedures phpmyadmin
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 useSET FOREIGN_KEY_CHECKS = 1
.
– Tim Biegeleisen
Nov 22 at 13:51
@TimBiegeleisen Do I have to includeSET 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
|
show 3 more comments
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
mysql stored-procedures phpmyadmin
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
mysql stored-procedures phpmyadmin
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 useSET FOREIGN_KEY_CHECKS = 1
.
– Tim Biegeleisen
Nov 22 at 13:51
@TimBiegeleisen Do I have to includeSET 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
|
show 3 more comments
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 useSET FOREIGN_KEY_CHECKS = 1
.
– Tim Biegeleisen
Nov 22 at 13:51
@TimBiegeleisen Do I have to includeSET 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
|
show 3 more comments
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.
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
add a comment |
up vote
0
down vote
accepted
I found the solution. When I was executing the stored-procedure I had the following box checked.
add a comment |
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.
I found the solution. When I was executing the stored-procedure I had the following box checked.
answered Nov 22 at 14:27
zinon
1,48442963
1,48442963
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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