Basic calculator procedure in MySQL The 2019 Stack Overflow Developer Survey Results Are...
How to type a long/em dash `—`
Output the Arecibo Message
Inverse Relationship Between Precision and Recall
If a sorcerer casts the Banishment spell on a PC while in Avernus, does the PC return to their home plane?
Old scifi movie from the 50s or 60s with men in solid red uniforms who interrogate a spy from the past
Can there be female White Walkers?
Can we generate random numbers using irrational numbers like π and e?
Does HR tell a hiring manager about salary negotiations?
Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?
Slides for 30 min~1 hr Skype tenure track application interview
What is the meaning of Triage in Cybersec world?
What is this sharp, curved notch on my knife for?
What is the motivation for a law requiring 2 parties to consent for recording a conversation
Is it correct to say the Neural Networks are an alternative way of performing Maximum Likelihood Estimation? if not, why?
How to obtain a position of last non-zero element
What is the light source in the black hole images?
How do I free up internal storage if I don't have any apps downloaded?
How can I define good in a religion that claims no moral authority?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Why “相同意思的词” is called “同义词” instead of "同意词"？
"as much details as you can remember"
I am an eight letter word. What am I?
Button changing its text & action. Good or terrible?
Can you cast a spell on someone in the Ethereal Plane, if you are on the Material Plane and have the True Seeing spell active?
Basic calculator procedure in MySQL
The 2019 Stack Overflow Developer Survey Results Are InBasic android calculatorBasic modular calculatorBasic CalculatorBasic web calculatorBasic Java Swing CalculatorBasic calculator in JavaBasic C# calculator codeBasic Calculator in Java 8My Basic Tax CalculatorBasic calculator in Python
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
$begingroup$
For a homework assignment, we were tasked to create a basic calculator in MySQL and store it in a procedure. I believe I did a solid job but am looking to see where I can improve.
DELIMITER $$
CREATE PROCEDURE Calculate(IN Num1 INT, IN Num2 INT, IN operation VARCHAR(100))
BEGIN
IF operation = "add" THEN
SELECT Num1 + Num2;
ELSEIF operation = "subtract" THEN
SELECT Num1 - Num2;
ELSEIF operation = "multiply" THEN
SELECT Num1 * Num2;
ELSEIF operation = "divide" THEN
SELECT Num1 / Num2;
ELSE
SELECT "Operation not available.";
END IF;
END $$
DELIMITER ;
Call Calculate(1,2,"multiply");
mysql homework calculator stored-procedure
edited 6 mins ago
200_success
131k17157422
asked 46 mins ago
Frank DoeFrank Doe
7215
$endgroup$
add a comment |
$begingroup$
For a homework assignment, we were tasked to create a basic calculator in MySQL and store it in a procedure. I believe I did a solid job but am looking to see where I can improve.
DELIMITER $$
CREATE PROCEDURE Calculate(IN Num1 INT, IN Num2 INT, IN operation VARCHAR(100))
BEGIN
IF operation = "add" THEN
SELECT Num1 + Num2;
ELSEIF operation = "subtract" THEN
SELECT Num1 - Num2;
ELSEIF operation = "multiply" THEN
SELECT Num1 * Num2;
ELSEIF operation = "divide" THEN
SELECT Num1 / Num2;
ELSE
SELECT "Operation not available.";
END IF;
END $$
DELIMITER ;
Call Calculate(1,2,"multiply");
mysql homework calculator stored-procedure
edited 6 mins ago
200_success
131k17157422
asked 46 mins ago
Frank DoeFrank Doe
7215
$endgroup$
add a comment |
$begingroup$
For a homework assignment, we were tasked to create a basic calculator in MySQL and store it in a procedure. I believe I did a solid job but am looking to see where I can improve.
DELIMITER $$
CREATE PROCEDURE Calculate(IN Num1 INT, IN Num2 INT, IN operation VARCHAR(100))
BEGIN
IF operation = "add" THEN
SELECT Num1 + Num2;
ELSEIF operation = "subtract" THEN
SELECT Num1 - Num2;
ELSEIF operation = "multiply" THEN
SELECT Num1 * Num2;
ELSEIF operation = "divide" THEN
SELECT Num1 / Num2;
ELSE
SELECT "Operation not available.";
END IF;
END $$
DELIMITER ;
Call Calculate(1,2,"multiply");
mysql homework calculator stored-procedure
edited 6 mins ago
200_success
131k17157422
asked 46 mins ago
Frank DoeFrank Doe
7215
$endgroup$
For a homework assignment, we were tasked to create a basic calculator in MySQL and store it in a procedure. I believe I did a solid job but am looking to see where I can improve.
DELIMITER $$
CREATE PROCEDURE Calculate(IN Num1 INT, IN Num2 INT, IN operation VARCHAR(100))
BEGIN
IF operation = "add" THEN
SELECT Num1 + Num2;
ELSEIF operation = "subtract" THEN
SELECT Num1 - Num2;
ELSEIF operation = "multiply" THEN
SELECT Num1 * Num2;
ELSEIF operation = "divide" THEN
SELECT Num1 / Num2;
ELSE
SELECT "Operation not available.";
END IF;
END $$
DELIMITER ;
Call Calculate(1,2,"multiply");
mysql homework calculator stored-procedure
mysql homework calculator stored-procedure
edited 6 mins ago
200_success
131k17157422
asked 46 mins ago
Frank DoeFrank Doe
7215
edited 6 mins ago
200_success
131k17157422
asked 46 mins ago
Frank DoeFrank Doe
7215
edited 6 mins ago
200_success
131k17157422
edited 6 mins ago
200_success
131k17157422
edited 6 mins ago
200_success
131k17157422
131k17157422
asked 46 mins ago
Frank DoeFrank Doe
7215
asked 46 mins ago
Frank DoeFrank Doe
7215
asked 46 mins ago
Frank DoeFrank Doe
7215
7215
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["\$", "\$"]]);
});
});
}, "mathjax-editing");
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: "196"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fcodereview.stackexchange.com%2fquestions%2f217293%2fbasic-calculator-procedure-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 Code Review Stack Exchange!
- 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.
Use MathJax to format equations. MathJax reference.
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%2fcodereview.stackexchange.com%2fquestions%2f217293%2fbasic-calculator-procedure-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
