Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT returns Broken Tables

Status
Not open for further replies.

BigBrother

Programmer
Jul 9, 2001
10
0
0
US
When I run SELECT field_01 FROM table_01, where field_01 is of type TEXT, mySQL returns a broken table with the rows all miss-aligned.

Could this be because TEXT is a variable-length type? Is there a fix for this? Can the contents of a field be wrapped so to fit within the table?
 
I was viewing the query in an MS DOS window. However, queries on other tables viewed in the same window run without a problem.
 
Then I think you answered part of your original question about the field being variable length. I don't know how to control the formatting of the output to the console window, however. :-(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top