create a query on table....??

[Efrain]

hello,
Using Browser v. 1.1.15, Windows XP Pro, MySQL 4.1.11-nt. Create a query on table with ten or more fields. Use "Select * from table_name;"

1. The resultset display runs off the screen to the right.
2. The column width is 2-4 times as long as the data displayed.
3. Adjust the column widths so all display nicely on the screen. Little or no empty space.
4. Re-execute the query.
5. The resultset display is now spread out again.

How to work around?
thanx! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[ishac]

often the data is much less than what is specified in the column type. So the set column width appears much wider than necessary. but some records contain much more data and without reading all records we cannot decide. So, not an option to bind the automatic column width to the actual data.

Hence, keep the column width a user has set for a specific column or even a specifc datatype and use this value for all further result sets. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --