Hi, On Thu, 2002-10-10 at 10:57, kayamboo wrote: > 1. Is there anyway to know the string value of the password using the > encrypted value , from the mysql.user table ?
No. It's scrambled with a one-way (lossy) algorithm. > 2. How can I know the most recently entered record, that does not have an > AUTOINCREMENT column ? You can't. Rows are by definition un-ordered in SQL databases, because storage is an internal matter for the server, it can do it any way it sees fit (it'll depend on the format, and other considerations like filling gaps of deleted rows, etc). The only logical ordering is one you put in (with AUTO_INCREMENT or timestamps or whatever). Actually you would only see that order if you use SELECT ... ORDER BY ... Otherwise, output is also unordered! (the fact that it may appear ordered while not using ORDER BY is purely coincidence: delete a row and insert a new one and you'll definitely find more disorder ;-) Regards, Arjen. -- MySQL Training in Auckland and Sydney, http://www.mysql.com/training/ Purchase Training, Support, Licenses @ https://order.mysql.com/?marl __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
