Issue with SQL Non-negatives and TinyInt
So in this assignment I was given the specific instruction:
"Add a new driver_age column to the drivers table with a TINYINT(2) data type that must not be a negative value and can’t be null."
So I put the following code into the system:
`ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) NOT NULL;`
I keep getting an error from the system saying:
[Error]: Task 2. Expected: Add a new driver_age column to the drivers
table with the specified data type. Try again.
This is done in Codio which auto-grades my code. I think it has something to do with TINYINT being able to go negative but now I don't know how to correct that parameter.
mysql sql alter-table
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
asked Nov 15 '18 at 5:05
SarahSarah
202
add a comment |
So in this assignment I was given the specific instruction:
"Add a new driver_age column to the drivers table with a TINYINT(2) data type that must not be a negative value and can’t be null."
So I put the following code into the system:
`ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) NOT NULL;`
I keep getting an error from the system saying:
[Error]: Task 2. Expected: Add a new driver_age column to the drivers
table with the specified data type. Try again.
This is done in Codio which auto-grades my code. I think it has something to do with TINYINT being able to go negative but now I don't know how to correct that parameter.
mysql sql alter-table
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
asked Nov 15 '18 at 5:05
SarahSarah
202
add a comment |
So in this assignment I was given the specific instruction:
"Add a new driver_age column to the drivers table with a TINYINT(2) data type that must not be a negative value and can’t be null."
So I put the following code into the system:
`ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) NOT NULL;`
I keep getting an error from the system saying:
[Error]: Task 2. Expected: Add a new driver_age column to the drivers
table with the specified data type. Try again.
This is done in Codio which auto-grades my code. I think it has something to do with TINYINT being able to go negative but now I don't know how to correct that parameter.
mysql sql alter-table
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
asked Nov 15 '18 at 5:05
SarahSarah
202
So in this assignment I was given the specific instruction:
"Add a new driver_age column to the drivers table with a TINYINT(2) data type that must not be a negative value and can’t be null."
So I put the following code into the system:
`ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) NOT NULL;`
I keep getting an error from the system saying:
[Error]: Task 2. Expected: Add a new driver_age column to the drivers
table with the specified data type. Try again.
This is done in Codio which auto-grades my code. I think it has something to do with TINYINT being able to go negative but now I don't know how to correct that parameter.
mysql sql alter-table
mysql sql alter-table
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
asked Nov 15 '18 at 5:05
SarahSarah
202
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
asked Nov 15 '18 at 5:05
SarahSarah
202
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
edited Nov 15 '18 at 5:14
Madhur Bhaiya
19.6k62236
19.6k62236
asked Nov 15 '18 at 5:05
SarahSarah
202
asked Nov 15 '18 at 5:05
SarahSarah
202
asked Nov 15 '18 at 5:05
SarahSarah
202
202
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can add UNSIGNED attribute to the TINYINT(2) so that it can never be negative.
ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) UNSIGNED NOT NULL;
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
add a comment |
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%2f53312757%2fissue-with-sql-non-negatives-and-tinyint%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can add UNSIGNED attribute to the TINYINT(2) so that it can never be negative.
ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) UNSIGNED NOT NULL;
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
add a comment |
You can add UNSIGNED attribute to the TINYINT(2) so that it can never be negative.
ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) UNSIGNED NOT NULL;
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
add a comment |
You can add UNSIGNED attribute to the TINYINT(2) so that it can never be negative.
ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) UNSIGNED NOT NULL;
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
You can add UNSIGNED attribute to the TINYINT(2) so that it can never be negative.
ALTER TABLE EPDriver.drivers ADD driver_age TINYINT(2) UNSIGNED NOT NULL;
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
answered Nov 15 '18 at 5:11
Madhur BhaiyaMadhur Bhaiya
19.6k62236
19.6k62236
add a comment |
add a comment |
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%2f53312757%2fissue-with-sql-non-negatives-and-tinyint%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
