How to change a password to AES_Encrypt with an update in MyPHP
This is a pretty basic problem i am having with MyPHP database where i have entered 25 password that i now need to change to AES_Encrypt.
*UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RandomKey`) = 2;*
I am using this code in SQL to update my tables but i'm getting an error message.
**Error
SQL query:
UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RevserseKey`) = 2
MySQL said:
Documentation #1054 - Unknown column 'Password01' in 'field list'**
It may just be a case of me forgetting to put a space somewhere but any help would be much appreciated.
php mysql database
edited Nov 23 at 6:51
enamoria
606521
asked Nov 23 at 1:09
Jimbo Gee
11
add a comment |
This is a pretty basic problem i am having with MyPHP database where i have entered 25 password that i now need to change to AES_Encrypt.
*UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RandomKey`) = 2;*
I am using this code in SQL to update my tables but i'm getting an error message.
**Error
SQL query:
UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RevserseKey`) = 2
MySQL said:
Documentation #1054 - Unknown column 'Password01' in 'field list'**
It may just be a case of me forgetting to put a space somewhere but any help would be much appreciated.
php mysql database
edited Nov 23 at 6:51
enamoria
606521
asked Nov 23 at 1:09
Jimbo Gee
11
The error is telling you that you're trying to reference a column calledPassword1which doesn't exist in that table. Do you think it should exist? Are you trying to do something other than reference a column? Why do you think this error message is wrong?
– David
Nov 23 at 1:13
Password01 is a string, and should be quoted in the query
– user10226920
Nov 23 at 1:22
add a comment |
This is a pretty basic problem i am having with MyPHP database where i have entered 25 password that i now need to change to AES_Encrypt.
*UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RandomKey`) = 2;*
I am using this code in SQL to update my tables but i'm getting an error message.
**Error
SQL query:
UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RevserseKey`) = 2
MySQL said:
Documentation #1054 - Unknown column 'Password01' in 'field list'**
It may just be a case of me forgetting to put a space somewhere but any help would be much appreciated.
php mysql database
edited Nov 23 at 6:51
enamoria
606521
asked Nov 23 at 1:09
Jimbo Gee
11
This is a pretty basic problem i am having with MyPHP database where i have entered 25 password that i now need to change to AES_Encrypt.
*UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RandomKey`) = 2;*
I am using this code in SQL to update my tables but i'm getting an error message.
**Error
SQL query:
UPDATE `EZY_Login` SET `Password` = AES_ENCRYPT(`Password01`, `RevserseKey`) = 2
MySQL said:
Documentation #1054 - Unknown column 'Password01' in 'field list'**
It may just be a case of me forgetting to put a space somewhere but any help would be much appreciated.
php mysql database
php mysql database
edited Nov 23 at 6:51
enamoria
606521
asked Nov 23 at 1:09
Jimbo Gee
11
edited Nov 23 at 6:51
enamoria
606521
asked Nov 23 at 1:09
Jimbo Gee
11
edited Nov 23 at 6:51
enamoria
606521
edited Nov 23 at 6:51
enamoria
606521
edited Nov 23 at 6:51
enamoria
606521
606521
asked Nov 23 at 1:09
Jimbo Gee
11
asked Nov 23 at 1:09
Jimbo Gee
11
asked Nov 23 at 1:09
Jimbo Gee
11
11
The error is telling you that you're trying to reference a column calledPassword1which doesn't exist in that table. Do you think it should exist? Are you trying to do something other than reference a column? Why do you think this error message is wrong?
– David
Nov 23 at 1:13
Password01 is a string, and should be quoted in the query
– user10226920
Nov 23 at 1:22
add a comment |
The error is telling you that you're trying to reference a column calledPassword1which doesn't exist in that table. Do you think it should exist? Are you trying to do something other than reference a column? Why do you think this error message is wrong?
– David
Nov 23 at 1:13
Password01 is a string, and should be quoted in the query
– user10226920
Nov 23 at 1:22
The error is telling you that you're trying to reference a column called
Password1 which doesn't exist in that table. Do you think it should exist? Are you trying to do something other than reference a column? Why do you think this error message is wrong?– David
Nov 23 at 1:13
The error is telling you that you're trying to reference a column called
Password1 which doesn't exist in that table. Do you think it should exist? Are you trying to do something other than reference a column? Why do you think this error message is wrong?– David
Nov 23 at 1:13
Password01 is a string, and should be quoted in the query
– user10226920
Nov 23 at 1:22
Password01 is a string, and should be quoted in the query
– user10226920
Nov 23 at 1:22
add a comment |
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%2f53439590%2fhow-to-change-a-password-to-aes-encrypt-with-an-update-in-myphp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53439590%2fhow-to-change-a-password-to-aes-encrypt-with-an-update-in-myphp%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
The error is telling you that you're trying to reference a column called
Password1which doesn't exist in that table. Do you think it should exist? Are you trying to do something other than reference a column? Why do you think this error message is wrong?– David
Nov 23 at 1:13
Password01 is a string, and should be quoted in the query
– user10226920
Nov 23 at 1:22