Menu
I am using phpMyAdmin v3.4.10.1deb1 to manage some MySQL-Tables on my Ubuntu-Server with fields that have the SQL-format "TEXT". When those fields are displayed, they are truncated by default. I always have to click on the Symbol "←T→" to expand the texts to their full length. But I don't want to do this click on every single query, because this means, that every query hat do be done twice.
I want that "full texts" is default. But I don't find the place where to set this.
Can you help?
628
Marc Delisle points out that the column may be hidden within phpMyAdmin; in the Browse tab look to the left of the column headers, there's a T with two arrows -- to the right of that is a small dropdown arrow. Make sure all your columns are selected there.
Click on the table you wish to modify. Inside the table, you will see a list of columns. To the right of the column name, you will see a link called "Change" under the Actions. Click on the Change link for the column you wish to modify.
PHPmyAdmin is installed but it has a bunch of databases installed as default. •cdcol (1) •information_schema (37) •mysql (24) •performance_schema (17) •phpmyadmin (8) •test •webauth (1)
PHPMyAdmin is able to handle unlimited amount of data when it comes to exporting a table to sql, csv or spreadsheets.
I have an option in the phpMyAdmin: Settings > Main Panel > Browse Mode called: Limit column characters where you can change the default limit of characters (50). But I don't believe you can set it to NOT limit by default...
Starting from phpMyAdmin 5, follow the comment below from Alan Dev : Home -> General settings -> More settings -> Main panel -> Browse mode -> Limit column characters
185
FIRST: Don't change core files if it is not necessary.
To achieve this in PMA version 4.5.4.1 you just have to add this line to your config.inc.php:
if ( !isset($_REQUEST['pftext'])) $_REQUEST['pftext'] = 'F'; This will always set the results to FULL TEXT per default, and you can switch over if you need to partial
23
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
