Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem in SQL (MySQL) select password column  RSS feed

 
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I created a password column using
Insert into table (password) values (PASSWORD(abc))
and ok,
but I can't select it back using
Select * from table where password="PASSWORD(abc)"
Or Select * from table where password=(Select PASSWORD(abc));
Empty set returned,why?
**I can only do it this way
1) Select PASSWORD(abc); get the encoded password
2) then Select * from table where password="Encoded String";
but I don't want to do in this indirect way
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've had the same problem. Can I guess that you're not running *nux and are in Windows instead?
If you search the MySQL docs, the password function is supported by the crypt() system call. This doesn't exist in Windows. I had a search and I think there are implementations you can plug in, but I never bothered...
Is this the problem you are having?
Dave.
 
Ken Shamrock
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for reply. Yes I m using WinXP.
I've figured out the reason why now. The password column should be exceeds 16 char, otherwise its not enough to stored the encoded string. Now it's ok
 
You ridiculous clown, did you think you could get away with it? This is my favorite tiny ad!
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!