CODEWITHSUNDEEP
mysqlmysql-workbench
user2022068
user2022068

Reputation:

Set fixed height of rows in select ouput

I use MySQL Workbench 6.2.4. When I make a select query for columns that contain, for example, html code, workbench makes the resulting rows very high. Some rows are of normal height, but some are too high. It's very difficult to work with such rows. Is it possible to make all rows with the same fixed height?

This is the image (I hid text with black color) enter image description here

Upvotes: 2

Views: 2258

Answers (1)

Rohit
Rohit

Reputation: 449

MySQL Workbench expands the height of a row if it is not able to display the data within a column due to the data length being on the higher side.

If you wish to see uniform rows, then there is a parameter called "Max.Field Value length to display (in bytes)" in Edit>Preferences>SQL Queries tab which can be modified. This value indicates the max length of each column to be displayed.

Suggest you reduce it to a small length & run the query again.

ps : check the screenshot. MySQL Workbench

Upvotes: 2

Related Questions