Basic calculator procedure 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
Relationship between Gromov-Witten and Taubes' Gromov invariant
What is this business jet?
What is the meaning of Triage in Cybersec world?
I am an eight letter word. What am I?
Can there be female White Walkers?
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
Why isn't the circumferential light around the M87 black hole's event horizon symmetric?
Can withdrawing asylum be illegal?
How did passengers keep warm on sail ships?
What is the most efficient way to store a numeric range?
Match Roman Numerals
Is one supposed to eat the zero'ah (shank bone) from the Seder plate?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
How to type a long/em dash `—`
If I can cast sorceries at instant speed, can I use sorcery-speed activated abilities at instant speed?
For what reasons would an animal species NOT cross a *horizontal* land bridge?
What information about me do stores get via my credit card?
How do I free up internal storage if I don't have any apps downloaded?
Why are there uneven bright areas in this photo of black hole?
How to support a colleague who finds meetings extremely tiring?
Inverse Relationship Between Precision and Recall
Slides for 30 min~1 hr Skype tenure track application interview
Accepted by European university, rejected by all American ones I applied to? Possible reasons?
Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?
Basic calculator procedure 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 homework calculator stored-procedure
edited 18 mins ago
200_success
131k17157422
asked 57 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 18 mins ago
200_success
131k17157422
asked 57 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 18 mins ago
200_success
131k17157422
asked 57 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 18 mins ago
200_success
131k17157422
asked 57 mins ago
Frank DoeFrank Doe
7215
edited 18 mins ago
200_success
131k17157422
asked 57 mins ago
Frank DoeFrank Doe
7215
edited 18 mins ago
200_success
131k17157422
edited 18 mins ago
200_success
131k17157422
edited 18 mins ago
200_success
131k17157422
131k17157422
asked 57 mins ago
Frank DoeFrank Doe
7215
asked 57 mins ago
Frank DoeFrank Doe
7215
asked 57 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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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
