Basic Calculator in MySQL The 2019 Stack Overflow Developer Survey Results Are InPHP MySQL...
Is it correct to say the Neural Networks are an alternative way of performing Maximum Likelihood Estimation? if not, why?
Currents/voltages graph for an electrical circuit
Cooking pasta in a water boiler
How to charge AirPods to keep battery healthy?
Falsification in Math vs Science
Output the Arecibo Message
Keeping a retro style to sci-fi spaceships?
How much of the clove should I use when using big garlic heads?
What do these terms in Caesar's Gallic wars mean?
What information about me do stores get via my credit card?
If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?
Why are there uneven bright areas in this photo of black hole?
Can a rogue use sneak attack with weapons that have the thrown property even if they are not thrown?
Did Scotland spend $250,000 for the slogan "Welcome to Scotland"?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?
Dropping list elements from nested list after evaluation
Deal with toxic manager when you can't quit
What is the most efficient way to store a numeric range?
Why couldn't they take pictures of a closer black hole?
What is this business jet?
What is this sharp, curved notch on my knife for?
Loose spokes after only a few rides
Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?
Basic Calculator in MySQL
The 2019 Stack Overflow Developer Survey Results Are InPHP MySQL grouping and orderingSimplify MySQL INSERT queryPython Connection with MySQLCalculator using PHP with logging to MySQL databaseoptimize mysql taking too longUpdate live table in MySQLGenerating a MySQL queryMySQL Database LibraryC++ - Insert into MySQL databaseMySQL CLI: Create a MySQL user & DB
.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
asked 4 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
asked 4 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
asked 4 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
mysql
asked 4 mins ago
Frank DoeFrank Doe
7215
asked 4 mins ago
Frank DoeFrank Doe
7215
asked 4 mins ago
Frank DoeFrank Doe
7215
asked 4 mins ago
Frank DoeFrank Doe
7215
asked 4 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-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-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
