Menu
This is an admittedly easy question, I just dont have the background in MySQL to know this and a google search has been fruitless. I have a MySQL table with a couple of mediumtext columns. When I run a SELECT query, with MySQL Workbench, it only shows me a truncated version of the contents. How can I see the entire contents of a mediumtext column within workbench? I'm sure its just a config setting I'm missing.
284
To view the database created on MySQL Workbench, navigate to Database > Connect to Database . Choose an existing connection to connect to MySQL Server or create a new one. The database created will be as shown in the screenshot below.
The first command you will need to use is the SELECT FROM MySQL statement that has the following syntax: SELECT * FROM table_name; This is a basic MySQL query which will tell the script to select all the records from the table_name table.
To open, right-click a table in the object browser of the Navigator pane and choose Table Inspector from the context menu. The Table Inspector shows information related to the table.
TINYTEXT can store up to 255 characters i.e 255 bytes. It is suitable for storing summaries of articles, short notices, captions, etc. It takes 1-Byte overhead. MEDIUMTEXT. MEDIUMTEXT can store up to 16,777,215 characters i.e 16,777,215 bytes or 64MB of data.
MEDIUMTEXT in the result pane and choose Open value in editor;
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
