i could not find the right syntax for triigers in mysql
this is the code, i have written. i could not correct this . i attached the error details also
thanks in advace
DELIMITER |
CREATE TRIGGER customer_check
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
IF NEW.customer_id NOT IN (select customer_id from customer) THEN
rollback;
END IF;
END |
DELIMITER ;
#Error
'chainmanagementsystem.sql': You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near 'DELIMITER | CREATE TRIGGER
customer_check AFTER INSERT ON orders FOR EACH ROW ' at line 1
mysql mysql-error-1064
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
asked Nov 20 '18 at 5:42
sivaramsivaram
41
add a comment |
this is the code, i have written. i could not correct this . i attached the error details also
thanks in advace
DELIMITER |
CREATE TRIGGER customer_check
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
IF NEW.customer_id NOT IN (select customer_id from customer) THEN
rollback;
END IF;
END |
DELIMITER ;
#Error
'chainmanagementsystem.sql': You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near 'DELIMITER | CREATE TRIGGER
customer_check AFTER INSERT ON orders FOR EACH ROW ' at line 1
mysql mysql-error-1064
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
asked Nov 20 '18 at 5:42
sivaramsivaram
41
Why not just have a foreign key constraint on orders:FOREIGN KEY (customer_id) REFERENCES customer(customer_id). What MariaDB version?
– danblack
Nov 20 '18 at 6:03
1
The error you get if you run this in command line sql is ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger. Can you explain what you are trying to do.
– P.Salmon
Nov 20 '18 at 7:31
add a comment |
this is the code, i have written. i could not correct this . i attached the error details also
thanks in advace
DELIMITER |
CREATE TRIGGER customer_check
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
IF NEW.customer_id NOT IN (select customer_id from customer) THEN
rollback;
END IF;
END |
DELIMITER ;
#Error
'chainmanagementsystem.sql': You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near 'DELIMITER | CREATE TRIGGER
customer_check AFTER INSERT ON orders FOR EACH ROW ' at line 1
mysql mysql-error-1064
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
asked Nov 20 '18 at 5:42
sivaramsivaram
41
this is the code, i have written. i could not correct this . i attached the error details also
thanks in advace
DELIMITER |
CREATE TRIGGER customer_check
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
IF NEW.customer_id NOT IN (select customer_id from customer) THEN
rollback;
END IF;
END |
DELIMITER ;
#Error
'chainmanagementsystem.sql': You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near 'DELIMITER | CREATE TRIGGER
customer_check AFTER INSERT ON orders FOR EACH ROW ' at line 1
mysql mysql-error-1064
mysql mysql-error-1064
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
asked Nov 20 '18 at 5:42
sivaramsivaram
41
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
asked Nov 20 '18 at 5:42
sivaramsivaram
41
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
edited Nov 20 '18 at 5:44
Madhur Bhaiya
19.6k62236
19.6k62236
asked Nov 20 '18 at 5:42
sivaramsivaram
41
asked Nov 20 '18 at 5:42
sivaramsivaram
41
asked Nov 20 '18 at 5:42
sivaramsivaram
41
41
Why not just have a foreign key constraint on orders:FOREIGN KEY (customer_id) REFERENCES customer(customer_id). What MariaDB version?
– danblack
Nov 20 '18 at 6:03
1
The error you get if you run this in command line sql is ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger. Can you explain what you are trying to do.
– P.Salmon
Nov 20 '18 at 7:31
add a comment |
Why not just have a foreign key constraint on orders:FOREIGN KEY (customer_id) REFERENCES customer(customer_id). What MariaDB version?
– danblack
Nov 20 '18 at 6:03
1
The error you get if you run this in command line sql is ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger. Can you explain what you are trying to do.
– P.Salmon
Nov 20 '18 at 7:31
Why not just have a foreign key constraint on orders:
FOREIGN KEY (customer_id) REFERENCES customer(customer_id). What MariaDB version?– danblack
Nov 20 '18 at 6:03
Why not just have a foreign key constraint on orders:
FOREIGN KEY (customer_id) REFERENCES customer(customer_id). What MariaDB version?– danblack
Nov 20 '18 at 6:03
1
1
The error you get if you run this in command line sql is ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger. Can you explain what you are trying to do.
– P.Salmon
Nov 20 '18 at 7:31
The error you get if you run this in command line sql is ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger. Can you explain what you are trying to do.
– P.Salmon
Nov 20 '18 at 7:31
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53386893%2fi-could-not-find-the-right-syntax-for-triigers-in-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53386893%2fi-could-not-find-the-right-syntax-for-triigers-in-mysql%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
Why not just have a foreign key constraint on orders:
FOREIGN KEY (customer_id) REFERENCES customer(customer_id). What MariaDB version?– danblack
Nov 20 '18 at 6:03
1
The error you get if you run this in command line sql is ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger. Can you explain what you are trying to do.
– P.Salmon
Nov 20 '18 at 7:31