Thanks. MySql has the Describe table function. Out of curiousity, Is there any shell that can show the binary (mediumblob) type? -----Original Message----- From: jeremi joslin [mailto:[email protected]] Sent: Thursday, June 01, 2006 10:27 AM To: [email protected] Subject: Re: [xwiki-dev] xwikiattachment_content table errors On 6/1/06, Roger Rukundo Nzabandora <[email protected]> wrote:
Hi all, thanks for the constant updates and info.
I'm trying to view the xwikiattachment_content table rows and columns in the windows command line but I don't get any meaningful results. The MySql command is select * from xwikiattachment_content. I get a series of several dotted lines followed by endless characters and the computer starts beeping endlessly until I have to close the command line interface. I'm doing a project on xwiki and I need to document the contents of each table. What can I do?
Hi, It's normal, because the content of this table is binary, so your shell have some problems to show the binary. Instead of listing the content of the database, you can use a function like "describe table"(i don't know if it exist en mysql, but you should have something like this) for watching the schema of the table. Can you share your work with the community after? Jérémi