Using concat and round togetherHow can I prevent SQL injection in PHP?Can I concatenate multiple MySQL rows into one field?How to output MySQL query results in CSV format?Find duplicate records in MySQLHow do I UPDATE from a SELECT in SQL Server?Finding duplicate values in a SQL tableSelect first row in each GROUP BY group?How to get the sizes of the tables of a MySQL database?Why shouldn't I use mysql_* functions in PHP?How to import an SQL file using the command line in MySQL?
dbcc cleantable batch size explanation
"You are your self first supporter", a more proper way to say it
Do I have a twin with permutated remainders?
LWC SFDX source push error TypeError: LWC1009: decl.moveTo is not a function
meaning of に in 本当に?
Does detail obscure or enhance action?
I'm flying to France today and my passport expires in less than 2 months
Is it possible to run Internet Explorer on OS X El Capitan?
DC-DC converter from low voltage at high current, to high voltage at low current
Replacing matching entries in one column of a file by another column from a different file
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
What would happen to a modern skyscraper if it rains micro blackholes?
Unable to deploy metadata from Partner Developer scratch org because of extra fields
How does quantile regression compare to logistic regression with the variable split at the quantile?
What is the word for reserving something for yourself before others do?
What's the point of deactivating Num Lock on login screens?
What typically incentivizes a professor to change jobs to a lower ranking university?
Can a Cauchy sequence converge for one metric while not converging for another?
How to format long polynomial?
Why doesn't H₄O²⁺ exist?
Horror movie about a virus at the prom; beginning and end are stylized as a cartoon
Revoked SSL certificate
How do I deal with an unproductive colleague in a small company?
What doth I be?
Using concat and round together
How can I prevent SQL injection in PHP?Can I concatenate multiple MySQL rows into one field?How to output MySQL query results in CSV format?Find duplicate records in MySQLHow do I UPDATE from a SELECT in SQL Server?Finding duplicate values in a SQL tableSelect first row in each GROUP BY group?How to get the sizes of the tables of a MySQL database?Why shouldn't I use mysql_* functions in PHP?How to import an SQL file using the command line in MySQL?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
CONCAT(ROUND(discount_percent, 0), %)
I want the output to look like this:
52%
mysql sql
edited Mar 9 at 0:59
Barmar
435k36260363
asked Mar 9 at 0:58
mandy drewmandy drew
11
add a comment |
CONCAT(ROUND(discount_percent, 0), %)
I want the output to look like this:
52%
mysql sql
edited Mar 9 at 0:59
Barmar
435k36260363
asked Mar 9 at 0:58
mandy drewmandy drew
11
5
You need quotes around%, just like any other string literal.
– Barmar
Mar 9 at 1:00
add a comment |
CONCAT(ROUND(discount_percent, 0), %)
I want the output to look like this:
52%
mysql sql
edited Mar 9 at 0:59
Barmar
435k36260363
asked Mar 9 at 0:58
mandy drewmandy drew
11
CONCAT(ROUND(discount_percent, 0), %)
I want the output to look like this:
52%
mysql sql
mysql sql
edited Mar 9 at 0:59
Barmar
435k36260363
asked Mar 9 at 0:58
mandy drewmandy drew
11
edited Mar 9 at 0:59
Barmar
435k36260363
asked Mar 9 at 0:58
mandy drewmandy drew
11
edited Mar 9 at 0:59
Barmar
435k36260363
edited Mar 9 at 0:59
Barmar
435k36260363
edited Mar 9 at 0:59
Barmar
435k36260363
435k36260363
asked Mar 9 at 0:58
mandy drewmandy drew
11
asked Mar 9 at 0:58
mandy drewmandy drew
11
asked Mar 9 at 0:58
mandy drewmandy drew
11
11
5
You need quotes around%, just like any other string literal.
– Barmar
Mar 9 at 1:00
add a comment |
5
You need quotes around%, just like any other string literal.
– Barmar
Mar 9 at 1:00
5
5
You need quotes around
%, just like any other string literal.– Barmar
Mar 9 at 1:00
You need quotes around
%, just like any other string literal.– Barmar
Mar 9 at 1:00
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%2f55072962%2fusing-concat-and-round-together%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%2f55072962%2fusing-concat-and-round-together%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
5
You need quotes around
%, just like any other string literal.– Barmar
Mar 9 at 1:00