MYSQL Procedure and Trigger
0
I need to create 1 procedure and 1 trigger which both logs insert of a car in Car-table: car(reg_nr, color, brand). I have created the trigger like this:
Create table CarLog(
ID integer,
User varchar (32),
Primary key (ID)
)engine=innodb;DELIMITER //
CREATE TRIGGER CarsLog AFTER INSERT ON Car
FOR EACH ROW BEGIN
INSERT INTO CarLog(User) values ( user() ) ;
END;
//
DELIMITER ;But how do I create a procedure which does the same thing as the trigger above?
mysql stored-procedures triggers
asked yesterday
Alex
21
add a comment |
0
I need to create 1 procedure and 1 trigger which both logs insert of a car in Car-table: car(reg_nr, color, brand). I have created the trigger like this:
Create table CarLog(
ID integer,
User varchar (32),
Primary key (ID)
)engine=innodb;DELIMITER //
CREATE TRIGGER CarsLog AFTER INSERT ON Car
FOR EACH ROW BEGIN
INSERT INTO CarLog(User) values ( user() ) ;
END;
//
DELIMITER ;But how do I create a procedure which does the same thing as the trigger above?
mysql stored-procedures triggers
asked yesterday
Alex
21
There is no such thing as an after insert procedure. If you don't know how to create a procedure please read dev.mysql.com/doc/refman/8.0/en/create-procedure.html
– P.Salmon
yesterday
Why do you want this available as a procedure AND as a trigger ? There is not enough context to your question to give a proper answer
– GMB
yesterday
add a comment |
0
0
0
I need to create 1 procedure and 1 trigger which both logs insert of a car in Car-table: car(reg_nr, color, brand). I have created the trigger like this:
Create table CarLog(
ID integer,
User varchar (32),
Primary key (ID)
)engine=innodb;DELIMITER //
CREATE TRIGGER CarsLog AFTER INSERT ON Car
FOR EACH ROW BEGIN
INSERT INTO CarLog(User) values ( user() ) ;
END;
//
DELIMITER ;But how do I create a procedure which does the same thing as the trigger above?
mysql stored-procedures triggers
asked yesterday
Alex
21
I need to create 1 procedure and 1 trigger which both logs insert of a car in Car-table: car(reg_nr, color, brand). I have created the trigger like this:
Create table CarLog(
ID integer,
User varchar (32),
Primary key (ID)
)engine=innodb;DELIMITER //
CREATE TRIGGER CarsLog AFTER INSERT ON Car
FOR EACH ROW BEGIN
INSERT INTO CarLog(User) values ( user() ) ;
END;
//
DELIMITER ;But how do I create a procedure which does the same thing as the trigger above?
Create table CarLog(
ID integer,
User varchar (32),
Primary key (ID)
)engine=innodb;Create table CarLog(
ID integer,
User varchar (32),
Primary key (ID)
)engine=innodb;DELIMITER //
CREATE TRIGGER CarsLog AFTER INSERT ON Car
FOR EACH ROW BEGIN
INSERT INTO CarLog(User) values ( user() ) ;
END;
//
DELIMITER ;DELIMITER //
CREATE TRIGGER CarsLog AFTER INSERT ON Car
FOR EACH ROW BEGIN
INSERT INTO CarLog(User) values ( user() ) ;
END;
//
DELIMITER ;mysql stored-procedures triggers
mysql stored-procedures triggers
asked yesterday
Alex
21
asked yesterday
Alex
21
asked yesterday
Alex
21
asked yesterday
Alex
21
asked yesterday
Alex
21
21
There is no such thing as an after insert procedure. If you don't know how to create a procedure please read dev.mysql.com/doc/refman/8.0/en/create-procedure.html
– P.Salmon
yesterday
Why do you want this available as a procedure AND as a trigger ? There is not enough context to your question to give a proper answer
– GMB
yesterday
add a comment |
There is no such thing as an after insert procedure. If you don't know how to create a procedure please read dev.mysql.com/doc/refman/8.0/en/create-procedure.html
– P.Salmon
yesterday
Why do you want this available as a procedure AND as a trigger ? There is not enough context to your question to give a proper answer
– GMB
yesterday
There is no such thing as an after insert procedure. If you don't know how to create a procedure please read dev.mysql.com/doc/refman/8.0/en/create-procedure.html
– P.Salmon
yesterday
There is no such thing as an after insert procedure. If you don't know how to create a procedure please read dev.mysql.com/doc/refman/8.0/en/create-procedure.html
– P.Salmon
yesterday
Why do you want this available as a procedure AND as a trigger ? There is not enough context to your question to give a proper answer
– GMB
yesterday
Why do you want this available as a procedure AND as a trigger ? There is not enough context to your question to give a proper answer
– GMB
yesterday
add a comment |
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
});
}
});
draft saved
draft discarded
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%2f53944529%2fmysql-procedure-and-trigger%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
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%2f53944529%2fmysql-procedure-and-trigger%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
There is no such thing as an after insert procedure. If you don't know how to create a procedure please read dev.mysql.com/doc/refman/8.0/en/create-procedure.html
– P.Salmon
yesterday
Why do you want this available as a procedure AND as a trigger ? There is not enough context to your question to give a proper answer
– GMB
yesterday