Hi!
>>>>> "Basil" == Basil Hussain <[EMAIL PROTECTED]> writes:
Basil> Hi,
>> I am BEGGING you to please make the describe command OPTIONALLY display the
>> Privileges column. Before 3.23, I was able to see the describes properly. Now
>> the command is almost totally useless to me!
Basil> I agree! On any table you care to describe the output is usually always
Basil> wider than even a 120 character display because of the privileges column. It
Basil> would indeed be much better if this column was optional. After all, you
Basil> don't always want to know what privileges you have on columns in a table.
Basil> I have a suggestion for an addition to the syntax to solve this problem. By
Basil> default DESCRIBE or SHOW COLUMNS would not show privilege information, but
Basil> if you did want to see privileges too, you would enter something like this:
Basil> DESCRIBE tablename WITH PRIVILEGES
Basil> SHOW COLUMNS FROM tablename WITH PRIVILEGES
Basil> Anyway, in the meantime, you can always show the query output in vertical
Basil> mode by terminating with '\G', rather than ';' or '\g'. But then again, this
Basil> poses it's own problems with scrolling (but you could probably use the new
Basil> pager command in the most recent 3.23 clients).
Basil> Regards,
I agree that the table list is a bit hard to read now.
I have now changed this in 3.23.32 that should hopefully be released
tomorrow.
As we already had 'SHOW FULL PROCESSLIST', I used the same syntax
here. Now you only get to see the privileges if you specify
'SHOW FULL COLUMNS FROM tablename'
Regards,
Monty
PS: I just hope no client is depending on this to work..
---------------------------------------------------------------------
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
