At 08:12 09.08.2002 -0400, you wrote:
Robin Johnson wrote:
On Thu, 8 Aug 2002, Marc Delisle wrote:
can I assume that the password is always the third field of mysql.user?
I don't think so.
Why not just specify the fields you want, in the order you want in your query?
Because the goal is to find if the name of the password field in mysql.user is Password or password, and I wanted to avoid doing a loop for each of the fields, looking for "assword".
I am implementing the fix in user_details as is, maybe someone will come with a better solution.
hmm dont know why it would be different (Password or password) but how about a simple solution *G*
show fields from mysql.user like "%assword"
Marc
This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel